Tag Archives: microsoft
腾龙公司开户要怎么注册?M3669857420
盛世集团公司开户注册账号,通常需要遵循以下一般步骤: 准备相关资料:可能包括个人或企业的身份证明、联系方式、地址证明等。 联系盛世集团:通过其官方网站、客服渠道等,了解具体的开户注册流程和所需资料要求。 填写申请表格:按照要求如实填写相关信息。 提交资料:将准备好的资料提交给盛世集团,可以通过线上上传或线路下提交的方式。 等待审核:公司对提交的资料进行审核。注册:审核通过后,即可成功开户注册账号。需要注意的是,具体的步骤和要求可能因盛世集团的规定而有所不同。建议你直接与该公司进行详细沟通,以确保顺利完成开户注册。以上只是一个大致的流程示例,实际操作中可能还有更多细节和特定要求。
盛世集团公司开户注册账号,通常需要遵循以下一般步骤: 准备相关资料:可能包括个人或企业的身份证明、联系方式、地址证明等。 联系盛世集团:通过其官方网站、客服渠道等,了解具体的开户注册流程和所需资料要求。 填写申请表格:按照要求如实填写相关信息。 提交资料:将准备好的资料提交给盛世集团,可以通过线上上传或线路下提交的方式。 等待审核:公司对提交的资料进行审核。注册:审核通过后,即可成功开户注册账号。需要注意的是,具体的步骤和要求可能因盛世集团的规定而有所不同。建议你直接与该公司进行详细沟通,以确保顺利完成开户注册。以上只是一个大致的流程示例,实际操作中可能还有更多细节和特定要求。 Read More
Not able to open files in IE mode
I’ve been trying to open a local pdf file in IE mode, every time I try to reload the file in internet explorer mode this dialogue is appearing. It says to open or save the file, If I’m trying to open a file then it is opening in edge not in IE mode.
I’ve been trying to open a local pdf file in IE mode, every time I try to reload the file in internet explorer mode this dialogue is appearing. It says to open or save the file, If I’m trying to open a file then it is opening in edge not in IE mode. Read More
Background issue in Win 11
I have two virtual desktop screens in my laptop funnily enough one of the background is different from other
And if i try to add a new desktop
which ever desktop i am highlighting that background gets replicated.
I am not sure if this a feature or a bug.
Any explanation for this?
I have two virtual desktop screens in my laptop funnily enough one of the background is different from other And if i try to add a new desktop which ever desktop i am highlighting that background gets replicated. I am not sure if this a feature or a bug. Any explanation for this? Read More
Print Preview Failed from Web Browsers
Unable to print from Web browsers, both Chrome and Edge. When printing, it shows the error Print Preview Failed, and the available printer is greyed out. Attached is a picture for your reference. Can someone help me troubleshoot the issue.
OS: Windows 11
browsers are Chrome and Edge
I tried the following without any success:
I tried to print from both browsers and got the same error I logged into another user account and getting the same error I reinstalled the printer driver Reset both browsers and update to latest version
Note: This PC was upgraded from Windows 10 to 11 recently, and it is a member of a domain.
Unable to print from Web browsers, both Chrome and Edge. When printing, it shows the error Print Preview Failed, and the available printer is greyed out. Attached is a picture for your reference. Can someone help me troubleshoot the issue.OS: Windows 11 browsers are Chrome and EdgeI tried the following without any success:I tried to print from both browsers and got the same error I logged into another user account and getting the same error I reinstalled the printer driver Reset both browsers and update to latest versionNote: This PC was upgraded from Windows 10 to 11 recently, and it is a member of a domain.Print Preview Failed Read More
PowerQuery Question: = Folder.Files() opens all sheets in Workbooks
I’m automating a PowerQuery to open monthly reports.
blank query for “FolderLocation” where I store new = Folder.Files(FolderLocation) to open them (but I only want ONE sheet not all sheets)then, Add Column/Custom Column/= Excel.Workbook([Custom], true)
That converts them all to tables for additional use… but… weird stuff happens.
some of the reports are already tables and I get duplicatessome of the reports are sheets not tables and THOSE workbooks have multiple sheets. One sheet is the data I want and the other sheets are pivot or formula tables.
I just want to bring in the data sheet. Since I’m automating it, I’m happy to spend the time now typing in the name of the sheet if there is a formula for that.
Q1 – how do I keep from getting duplicate entries opening a single table workbook
Q2 – how do I get Folder.File to open one sheet of a workbook
thanks!
mm
I’m automating a PowerQuery to open monthly reports. blank query for “FolderLocation” where I store new = Folder.Files(FolderLocation) to open them (but I only want ONE sheet not all sheets)then, Add Column/Custom Column/= Excel.Workbook([Custom], true) That converts them all to tables for additional use… but… weird stuff happens. some of the reports are already tables and I get duplicatessome of the reports are sheets not tables and THOSE workbooks have multiple sheets. One sheet is the data I want and the other sheets are pivot or formula tables.I just want to bring in the data sheet. Since I’m automating it, I’m happy to spend the time now typing in the name of the sheet if there is a formula for that. Q1 – how do I keep from getting duplicate entries opening a single table workbookQ2 – how do I get Folder.File to open one sheet of a workbook thanks! mm Read More
AptX Audio Codecs on X Elite Linup
Recently purchased the Sennheiser Momentum 4 and have been loving them. I also upgraded my Surface Pro 7 to the new Surface Pro 11 with the Qualcomm X Elite Chip. I was really excited because the chip supports the AptX Adaptive audio codec which is what the Momentum 4 uses for high quality audio, but when I tried it out today I’m only getting the AAC Codec (much lower quality).
Is this just a Windows issue? Will AptX support be coming in a future update? It would be really frustrating to not be able to listen to high quality playback because of a software issue
Recently purchased the Sennheiser Momentum 4 and have been loving them. I also upgraded my Surface Pro 7 to the new Surface Pro 11 with the Qualcomm X Elite Chip. I was really excited because the chip supports the AptX Adaptive audio codec which is what the Momentum 4 uses for high quality audio, but when I tried it out today I’m only getting the AAC Codec (much lower quality).Is this just a Windows issue? Will AptX support be coming in a future update? It would be really frustrating to not be able to listen to high quality playback because of a software issue Read More
Best way to redo a corrupted login | Intune
I work for an actively growing engineering firm and our domain is hybrid on-prem + AAD with a semi-recent rollout of Intune (so we are a little green with how it works)
One of my user’s computer login is showing signs of corruption so we wanted to backup and remove the profile from the machine without disrupting Intune enrollment or reinstalling Windows (which we will only do as a last resort with this user.)
Pre-MDM, removing was fairly easy from a service account which literally renaming that user folder in the Users folder then removing the user from Advanced System Settings. Then having the user sign back in which would rebuild a new, clean user profile.
But now, Intune is protecting the profile (as it was used to enroll in Intune) making this old process impossible. Even with network adapters disabled or in Safe Mode.
Is there a way to do re-do a corrupted user profile without removing the computer from the domain?
The delete option in Intune will remove a computer, but I noticed that re-enrolling in Intune with another account typically doesn’t work in our tenant. So, I am trying to avoid using the Delete option in Intune. A little guidance as we are new to Intune.
I work for an actively growing engineering firm and our domain is hybrid on-prem + AAD with a semi-recent rollout of Intune (so we are a little green with how it works)One of my user’s computer login is showing signs of corruption so we wanted to backup and remove the profile from the machine without disrupting Intune enrollment or reinstalling Windows (which we will only do as a last resort with this user.)Pre-MDM, removing was fairly easy from a service account which literally renaming that user folder in the Users folder then removing the user from Advanced System Settings. Then having the user sign back in which would rebuild a new, clean user profile.But now, Intune is protecting the profile (as it was used to enroll in Intune) making this old process impossible. Even with network adapters disabled or in Safe Mode.Is there a way to do re-do a corrupted user profile without removing the computer from the domain?The delete option in Intune will remove a computer, but I noticed that re-enrolling in Intune with another account typically doesn’t work in our tenant. So, I am trying to avoid using the Delete option in Intune. A little guidance as we are new to Intune. Read More
If One Booking, Block Day
I have a scenario where if an hour block is booked on a day for a site visit, I want to block off the whole day so no one else can book that day. Any ideas on if or how we can do this in Bookings?
I have a scenario where if an hour block is booked on a day for a site visit, I want to block off the whole day so no one else can book that day. Any ideas on if or how we can do this in Bookings? Read More
What is the most efficient way to implement conditional formatting?
Hi,
I currently manage conditional formatting of cells that require a reasonably complex formula by placing a formula in a cell, then have the conditional formatting formula point to that cell.
My question is:
Am I sacrificing efficiency and speed by defining additional formulas in the sheet rather than configuring the formula in the conditional formatting dialogue?
For example, I have this formula in cell AG190.
=AND(OR(AG$172:AG$189),OR(Var1<10,Var1>18))
or more precisely, this formula is filled across cells AG190:AO190
Elsewhere, I have a range of cells with conditional formatting that simply refer to these cells i.e.
=AG$190
so using this example, my question is
would my sheet be more (or less) efficient/faster/slower if I placed the formula in the conditional formatting rule? i.e. change the =AG$190 to =AND(OR(AG$172:AG$189),OR(Var1<10,Var1>18)) and just forget about using the interim calculation cells?
TIA
RedNectar
Hi,I currently manage conditional formatting of cells that require a reasonably complex formula by placing a formula in a cell, then have the conditional formatting formula point to that cell.My question is:Am I sacrificing efficiency and speed by defining additional formulas in the sheet rather than configuring the formula in the conditional formatting dialogue?For example, I have this formula in cell AG190.=AND(OR(AG$172:AG$189),OR(Var1<10,Var1>18))or more precisely, this formula is filled across cells AG190:AO190Elsewhere, I have a range of cells with conditional formatting that simply refer to these cells i.e.=AG$190so using this example, my question is would my sheet be more (or less) efficient/faster/slower if I placed the formula in the conditional formatting rule? i.e. change the =AG$190 to =AND(OR(AG$172:AG$189),OR(Var1<10,Var1>18)) and just forget about using the interim calculation cells?TIARedNectar Read More
Staff Contingent on Days Booked
I have a scenario where a service is offered three days of the week, but bookings need to be contingent on three staff members’ calendars the first two days and only two of those staff members the third day. Is there a way to tell it to not look at that third member calendar on the third day for availability?
I have a scenario where a service is offered three days of the week, but bookings need to be contingent on three staff members’ calendars the first two days and only two of those staff members the third day. Is there a way to tell it to not look at that third member calendar on the third day for availability? Read More
why i can’t search in notes in contacts in new outlook like old outlook
what’s the point of a new outlook if it has less future than the old outlook
I can’t search in notes in contacts in new outlook like old outlook,
what’s the point of a new outlook if it has less future than the old outlook I can’t search in notes in contacts in new outlook like old outlook, Read More
COMBINING 2 SHEETS
I have to sheets one has real estate property owner info & the other has real estate property details
The one thig they share is the property address & a few columns
How can I combine them into one sheet
I have to sheets one has real estate property owner info & the other has real estate property details The one thig they share is the property address & a few columns How can I combine them into one sheet Read More
Formula to locate the date from a list of dates that is less than but closest to a specific date
I have a column of specific dates (sprint end dates). When determining delivery milestone dates for a project, I need to know which sprint a milestone date falls in. I can look it up manually but where is the fun in that?
For example: if a project estimate determines a design must be completed by 11/10, I want to know the sprint end date of the sprint it would fall into?
Data Table:SprintStart DateEnd DateOCT24-2110/9/202410/22/2024OCT24-2210/23/202411/5/2024NOV24-2311/6/202411/19/2024NOV24-2411/20/202412/3/2024DEC24-2512/4/202412/17/2024DEC24-2612/18/202412/31/2024 Milestone date:11/10/2024 Sprint End Date:11/19/2024
I have a column of specific dates (sprint end dates). When determining delivery milestone dates for a project, I need to know which sprint a milestone date falls in. I can look it up manually but where is the fun in that? For example: if a project estimate determines a design must be completed by 11/10, I want to know the sprint end date of the sprint it would fall into?Data Table:SprintStart DateEnd DateOCT24-2110/9/202410/22/2024OCT24-2210/23/202411/5/2024NOV24-2311/6/202411/19/2024NOV24-2411/20/202412/3/2024DEC24-2512/4/202412/17/2024DEC24-2612/18/202412/31/2024 Milestone date:11/10/2024 Sprint End Date:11/19/2024 Read More
Combine 2 unique row entries from a table into 1 consolidated row entry
So I’m hoping there’s a solution to this, but I’m not expert level at excel and can’t figure it out.
To give some background, I’m inputting sales data each month into a table that has thousands of different accounts. In the sales data that I’m pulling, some of the accounts have multiple locations (like a store and a warehouse) and the sales data will be separated into two separate unique rows with unique names, addresses, and account IDs.
For this example, let’s say I have two different rows that are reflected as “Account A Store” and “Account A Warehouse” (again both with unique addresses and unique account IDs with their own respective sales data).
Is there anyway to combine these two separate rows into one consolidated “Account A” row. Whether that be moving it into another Table or Pivot Table? Or can this be done with any formatting or VBA?
This example needs to be repeated, as there are numerous accounts like this, and I’m entering new sales data every month.
Thanks and I appreciate any help!
So I’m hoping there’s a solution to this, but I’m not expert level at excel and can’t figure it out. To give some background, I’m inputting sales data each month into a table that has thousands of different accounts. In the sales data that I’m pulling, some of the accounts have multiple locations (like a store and a warehouse) and the sales data will be separated into two separate unique rows with unique names, addresses, and account IDs. For this example, let’s say I have two different rows that are reflected as “Account A Store” and “Account A Warehouse” (again both with unique addresses and unique account IDs with their own respective sales data). Is there anyway to combine these two separate rows into one consolidated “Account A” row. Whether that be moving it into another Table or Pivot Table? Or can this be done with any formatting or VBA? This example needs to be repeated, as there are numerous accounts like this, and I’m entering new sales data every month. Thanks and I appreciate any help! Read More
PDF to Excel – Data Mining
Many years ago I used Monarch to perform data mining extracts from a payers 835 remittance advice into excel. We captured all elements spread throughout the PDF into single line item details. Sadly, the times have changed and what used to cost $150 for the Monarch CD to use is now totally different, costing over $5k for a yearly prescription cost.
I have attached a Mock PDF and a mock of what I want to see in excel. Any thoughts of a program that will not break my tiny little bank would be great. Or, using the data extract option in excel to work properly.
Many years ago I used Monarch to perform data mining extracts from a payers 835 remittance advice into excel. We captured all elements spread throughout the PDF into single line item details. Sadly, the times have changed and what used to cost $150 for the Monarch CD to use is now totally different, costing over $5k for a yearly prescription cost. I have attached a Mock PDF and a mock of what I want to see in excel. Any thoughts of a program that will not break my tiny little bank would be great. Or, using the data extract option in excel to work properly. Read More
Downloading Forms file
Can I download survey I created online using Microsoft forms?
I created survey online but I am unable to download it.
Silly question: Do Forms exist only online?
Can I download survey I created online using Microsoft forms?I created survey online but I am unable to download it.Silly question: Do Forms exist only online?forms Read More
[Azure Service Bus] JMS messages getting dead-lettered
The article discusses a problem where numerous messages end up in the dead letter queue (DLQ) when the JMS service bus consumer connects to the Azure Service Bus using Qpid jars. The reason for the messages being dead-lettered is that they have reached the maximum delivery count.
The fundamental issue stems from Apache Qpid’s message handling. Qpid utilizes a local buffer to prefetch messages from the Azure Service Bus, storing them prior to delivery to the consumer. The complication occurs when Qpid prefetches an excessive number of messages that the consumer is unable to process within the lock duration. Consequently, the consumer is unable to acknowledge or finalize the processing of these messages before the lock expires, leading to an accumulation of messages in the Dead Letter Queue (DLQ).
To address this problem, it is crucial to either turn off Qpid’s local buffer or modify the prefetch count. Disabling prefetching is achievable by setting jms.prefetchPolicy.all=0 in the JMS client. This configuration allows the JMS client to directly consume messages from the Azure Service Bus, circumventing Qpid’s local buffer. Consequently, the consumer can process messages at a suitable pace, guaranteeing smooth processing and issue-free completion.
Why is Prefetch not the default option in Microsoft .NET/Java/Python libs?
Microsoft Tech Community – Latest Blogs –Read More
Power Automate Post Loop Component to Teams
I have a daily post to a teams channel that includes a link to a Microsoft Loop. I would like the daily post to include the loop component. I haven’t found a way to include the component. Suggestions?
I have a daily post to a teams channel that includes a link to a Microsoft Loop. I would like the daily post to include the loop component. I haven’t found a way to include the component. Suggestions? Read More
Running MS Teams in Kiosk Mode on a Windows 11 desktop
I have a Kiosk (Windows 11) where MS Teams needs to be autolaunched, I have set it up in Intune for the Kiosk Mode as follows:
I am not sure which one should I autolaunch here?
Microsoft Teams or Microsoft Teams Autostart
Next, should I also have the Win32 App of MS Teams defined? If so there is an issue with the MS TEAMS installation location as it is not the location what I thought it was “%localappdata%MicrosoftTeamsCurrent”
So, where is the path that MS TEAMS should be defined
Also, I am not sure where to find this in the article on the Microsoft forum that shows the location of MS Teams. I do not see anything like this on my computer: “C:Program FilesWindowsAppsMSTeams_23272.2707.2453.769_x64__8wekyb3d8bbwems-teams.exe”. Will this path keep changing with newer versions of Teams? If so, how do updates happen, and how does it work in Kiosk mode if a new version of Teams is installed? I hope I am clear in what I am trying to say here.
Launching Teams from Stream Deck / location of New Teams exe – Microsoft Community
The next issue I see is that configuration I modified and applied is showing as pending. How long does this take to be successful. I did a manual sync and multiple times through Intune on the device, but it still is in this state for more than 3 to 4 hours.
I have a Kiosk (Windows 11) where MS Teams needs to be autolaunched, I have set it up in Intune for the Kiosk Mode as follows: I am not sure which one should I autolaunch here? Microsoft Teams or Microsoft Teams Autostart Next, should I also have the Win32 App of MS Teams defined? If so there is an issue with the MS TEAMS installation location as it is not the location what I thought it was “%localappdata%MicrosoftTeamsCurrent” So, where is the path that MS TEAMS should be defined Also, I am not sure where to find this in the article on the Microsoft forum that shows the location of MS Teams. I do not see anything like this on my computer: “C:Program FilesWindowsAppsMSTeams_23272.2707.2453.769_x64__8wekyb3d8bbwems-teams.exe”. Will this path keep changing with newer versions of Teams? If so, how do updates happen, and how does it work in Kiosk mode if a new version of Teams is installed? I hope I am clear in what I am trying to say here. Launching Teams from Stream Deck / location of New Teams exe – Microsoft Community The next issue I see is that configuration I modified and applied is showing as pending. How long does this take to be successful. I did a manual sync and multiple times through Intune on the device, but it still is in this state for more than 3 to 4 hours. Read More
OpenSSL Defender Vulnerabilities yet no OpenSSL Installed – Only OpenSSL Libs
Defender is alerting that there are vulns with OpenSSL needing updates on devices yet none actually have it installed. The paths are c:windowssystem32driverstorefilerepositoryiclsclient.inf_amd64_fc84dfa25a6a7727liblibcrypto-3-x64.dll and c:windowssystem32driverstorefilerepositoryiclsclient.inf_amd64_fc84dfa25a6a7727liblibssl-3-x64.dll
I don’t want to have to push out OpenSSL to all machines, but Microsoft isn’t including updates for these. Has anyone ran into this and found a fix?
Defender is alerting that there are vulns with OpenSSL needing updates on devices yet none actually have it installed. The paths are c:windowssystem32driverstorefilerepositoryiclsclient.inf_amd64_fc84dfa25a6a7727liblibcrypto-3-x64.dll and c:windowssystem32driverstorefilerepositoryiclsclient.inf_amd64_fc84dfa25a6a7727liblibssl-3-x64.dllI don’t want to have to push out OpenSSL to all machines, but Microsoft isn’t including updates for these. Has anyone ran into this and found a fix? Read More