Category: Microsoft
Category Archives: Microsoft
A notification from the update center indicates that a program update is available.
I have been receiving notifications from the system regarding updates for some of my programs. For instance, yesterday, I received a notification about an update for Corel VideoStudio X10. However, when I clicked on it, the notification disappeared. How can I check which programs have updates and how can I proceed with updating them? I tried searching online but all I found were results related to Windows 11 updates, which is not what I am looking for. I specifically need guidance on updating individual programs. Thank you for your assistance.
I have been receiving notifications from the system regarding updates for some of my programs. For instance, yesterday, I received a notification about an update for Corel VideoStudio X10. However, when I clicked on it, the notification disappeared. How can I check which programs have updates and how can I proceed with updating them? I tried searching online but all I found were results related to Windows 11 updates, which is not what I am looking for. I specifically need guidance on updating individual programs. Thank you for your assistance. Read More
Using Get-WinEvent to Retrieve Events within a Specific Time Period
Does anyone know if it is possible to define a time range when using Get-WinEvent in PowerShell? It appears to work when specifying StartTime, but encounters issues when setting both StartTime and EndTime.
Working example:
“`powershell
Get-WinEvent -FilterHashTable @{‘LogName’ = ‘Application’; ‘StartTime’ = Get-Date “November 26, 2023 14:00:00”; }
“`
Encountering issues:
“`powershell
Get-WinEvent -FilterHashTable @{‘LogName’ = ‘Application’; ‘StartTime’ = Get-Date “November 26, 2023 14:00:00”; ‘EndTime’ = Get-Date “November 26, 2023 14:01:00”}
Get-WinEvent : No events were found that match the specified selection criteria.
At line:1 char:1
+ Get-WinEvent -FilterHashTable @{LogName=’Application’;StartTime=’01/0 …
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+ CategoryInfo : ObjectNotFound: (:) [Get-WinEvent], Exception
+ FullyQualifiedErrorId : NoMatchingEventsFound,Microsoft.PowerShell.Commands.GetWinEventCommand
“`
Does anyone know if it is possible to define a time range when using Get-WinEvent in PowerShell? It appears to work when specifying StartTime, but encounters issues when setting both StartTime and EndTime. Working example:“`powershellGet-WinEvent -FilterHashTable @{‘LogName’ = ‘Application’; ‘StartTime’ = Get-Date “November 26, 2023 14:00:00”; }“` Encountering issues:“`powershellGet-WinEvent -FilterHashTable @{‘LogName’ = ‘Application’; ‘StartTime’ = Get-Date “November 26, 2023 14:00:00”; ‘EndTime’ = Get-Date “November 26, 2023 14:01:00”}Get-WinEvent : No events were found that match the specified selection criteria.At line:1 char:1+ Get-WinEvent -FilterHashTable @{LogName=’Application’;StartTime=’01/0 …+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~+ CategoryInfo : ObjectNotFound: (:) [Get-WinEvent], Exception+ FullyQualifiedErrorId : NoMatchingEventsFound,Microsoft.PowerShell.Commands.GetWinEventCommand“` Read More
FAQs on Installing Windows 10 and 11 via Windows To Go on External Drives
Greetings,
I am seeking guidance on the installation of Windows on external devices and would appreciate any assistance you can provide. My goal is to create a universal external device that contains installations of Windows 10 and 11 with a digital license purchased for a third party, using the information provided by them such as name, mobile number, and Gmail address.
1. Is it feasible to install Windows 10 and 11 on a new external device that is associated with a digital license linked to a Microsoft account different from the one on the host device to which the external device will be connected? Can I carry out this process on my desktop PC?
2. Will these external devices function properly on the third party’s PC who has shared their details with me?
3. To clarify further, I am looking to create a commercial external device on which Windows 11 and Windows 10 will be installed with a digital license connected to a Microsoft account, using the details provided by a third party. Is it possible to set this up on my desktop PC?
4. If the answer to the above questions is negative, are there any alternative solutions for creating a universal external device, possibly utilizing a local account of the third party and activating the digital license, so that the prepared device can be sold to them with the purchased license?
5. If the solution is affirmative, will the Microsoft server check my PC details and hardware configuration instead of those of the third party?
Thank you for your attention.
Greetings, I am seeking guidance on the installation of Windows on external devices and would appreciate any assistance you can provide. My goal is to create a universal external device that contains installations of Windows 10 and 11 with a digital license purchased for a third party, using the information provided by them such as name, mobile number, and Gmail address. 1. Is it feasible to install Windows 10 and 11 on a new external device that is associated with a digital license linked to a Microsoft account different from the one on the host device to which the external device will be connected? Can I carry out this process on my desktop PC? 2. Will these external devices function properly on the third party’s PC who has shared their details with me? 3. To clarify further, I am looking to create a commercial external device on which Windows 11 and Windows 10 will be installed with a digital license connected to a Microsoft account, using the details provided by a third party. Is it possible to set this up on my desktop PC? 4. If the answer to the above questions is negative, are there any alternative solutions for creating a universal external device, possibly utilizing a local account of the third party and activating the digital license, so that the prepared device can be sold to them with the purchased license? 5. If the solution is affirmative, will the Microsoft server check my PC details and hardware configuration instead of those of the third party? Thank you for your attention. Read More
Exploring new applications and updates on Windows 11
Good day everyone! I’ve made the choice to switch from W10 to W11 due to an issue with an installation that disrupted Aquasuite’s access to my hardware. Previously, I relied on Acronis Try and Decide to evaluate installations and changes to my system in a safe environment. Unfortunately, Try and Decide is not compatible with W11. How can I effectively test product installations or updates and revert back to a previous state?
One option is to conduct a full backup and recovery.
Alternatively, are there any other suggestions or methods you recommend for achieving this?
Good day everyone! I’ve made the choice to switch from W10 to W11 due to an issue with an installation that disrupted Aquasuite’s access to my hardware. Previously, I relied on Acronis Try and Decide to evaluate installations and changes to my system in a safe environment. Unfortunately, Try and Decide is not compatible with W11. How can I effectively test product installations or updates and revert back to a previous state? One option is to conduct a full backup and recovery. Alternatively, are there any other suggestions or methods you recommend for achieving this? Read More
Since 23H2, the network-volume-battery icons no longer open quick settings when clicked.
Title: “Infrequent Success: Right-Click Functionality Working Well for Three Features”
This feature, as the title suggests, experiences occasional success but is quite rare. However, the right-click functionality for these three features performs well consistently.
Do you have any suggestions? Thank you so much! 🙂
Title: “Infrequent Success: Right-Click Functionality Working Well for Three Features” This feature, as the title suggests, experiences occasional success but is quite rare. However, the right-click functionality for these three features performs well consistently. Do you have any suggestions? Thank you so much! 🙂 Read More
Uncertain of the Cause: Black Screen
Seeking advice…
As I worked on editing photos on my computer with music in the background, the screen suddenly went dark but the music kept playing. Upon pressing Ctrl Alt Delete, the menu displayed on the screen as usual. Opting to log out, I expected to see the login screen, but it wasn’t visible.
Thinking a thorough cleaning might help, I powered off the PC, unplugged it, and carefully removed and cleaned the graphics card and memory components before reassembling everything. However, upon powering it back on, the monitor received no signal.
After rechecking that all components were properly seated, I tried again, but alas, the monitor remained blank.
The PC seems to be functioning fine, only the screen shows no activity. It worked momentarily after using Ctrl Alt Delete to end the session, leaving me puzzled. Could this be a sign of a failing graphics card? I am uncertain, as the issue arose right after it initially appeared to be resolved. Any insights on what might be causing this perplexing situation?
Seeking advice… As I worked on editing photos on my computer with music in the background, the screen suddenly went dark but the music kept playing. Upon pressing Ctrl Alt Delete, the menu displayed on the screen as usual. Opting to log out, I expected to see the login screen, but it wasn’t visible. Thinking a thorough cleaning might help, I powered off the PC, unplugged it, and carefully removed and cleaned the graphics card and memory components before reassembling everything. However, upon powering it back on, the monitor received no signal. After rechecking that all components were properly seated, I tried again, but alas, the monitor remained blank. The PC seems to be functioning fine, only the screen shows no activity. It worked momentarily after using Ctrl Alt Delete to end the session, leaving me puzzled. Could this be a sign of a failing graphics card? I am uncertain, as the issue arose right after it initially appeared to be resolved. Any insights on what might be causing this perplexing situation? Read More
Preparing your New Laptop: Steps to Take Before Getting Started
Dear Experts,
I recently received my new HP Envy laptop and have invested a considerable amount of time updating and installing my office suite and Visio software. I am not fond of the factory reset process, so I am seeking advice on the best methods to create a full backup that will allow me to:
1. Restore my laptop to its current state with all the necessary software and files.
2. Maintain incremental backups for future changes and additions.
In addition to backup solutions, I would appreciate guidance on other important steps to take before fully utilizing my new laptop. Your assistance is highly valued.
Dear Experts, I recently received my new HP Envy laptop and have invested a considerable amount of time updating and installing my office suite and Visio software. I am not fond of the factory reset process, so I am seeking advice on the best methods to create a full backup that will allow me to:1. Restore my laptop to its current state with all the necessary software and files.2. Maintain incremental backups for future changes and additions. In addition to backup solutions, I would appreciate guidance on other important steps to take before fully utilizing my new laptop. Your assistance is highly valued. Read More
How to instal MathType into Word
I am using Microsoft Office 365 on a 2021 iMac M1 computer with 16 GB MEMORY running Sonoma 14.5. I have received a warning message that the MathType addon is not installed. When I try to install it, the Install Addons option is greyed out. I spent about 45 minutes with Microsoft Word support, and they did not know how to fix it, and referred me here. I have reinstalled Office 365 twice and that has not fixed the problem. Help me, please, if anyone can. Thanks
I am using Microsoft Office 365 on a 2021 iMac M1 computer with 16 GB MEMORY running Sonoma 14.5. I have received a warning message that the MathType addon is not installed. When I try to install it, the Install Addons option is greyed out. I spent about 45 minutes with Microsoft Word support, and they did not know how to fix it, and referred me here. I have reinstalled Office 365 twice and that has not fixed the problem. Help me, please, if anyone can. Thanks Read More
Return a value from a list based on the value of another cell
I am working on a schedule.
I have one master spreadsheet I want to input all my employees working on the shift in specific positions for the entire year.
I have other spreadsheets for each individual area. I want the area spreadsheets to populate from the master based off the date input on the area sheet.
So if BOB works on 1/1/24 in Area 1, spot 1 on the master sheet, I want to put the date into a cell on the area sheet and have BOB populate in the Area 1, spot 1 on the area sheet.
I hope this makes sense.
On the master sheet, the dates are across the top, and the positions are listed in the columns.
I am working on a schedule.I have one master spreadsheet I want to input all my employees working on the shift in specific positions for the entire year.I have other spreadsheets for each individual area. I want the area spreadsheets to populate from the master based off the date input on the area sheet.So if BOB works on 1/1/24 in Area 1, spot 1 on the master sheet, I want to put the date into a cell on the area sheet and have BOB populate in the Area 1, spot 1 on the area sheet.I hope this makes sense.On the master sheet, the dates are across the top, and the positions are listed in the columns. Read More
Protecting Specific Tabs in a Workbook from Viewing
Hi,
I am trying to see if there is a way to protect/block specific tabs in an Excel workbook from viewing, not just editing. And is there a way to give different permissions/vies/access to different users within the same workbook?
For Example on below spreadsheet, I would like some users to be able to view just the 1st and 2nd tab and not the Budget tab. And have other be able to view all other tabs.
I would appreciate any help or insight.
Thank you,
Hi, I am trying to see if there is a way to protect/block specific tabs in an Excel workbook from viewing, not just editing. And is there a way to give different permissions/vies/access to different users within the same workbook?For Example on below spreadsheet, I would like some users to be able to view just the 1st and 2nd tab and not the Budget tab. And have other be able to view all other tabs.I would appreciate any help or insight.Thank you, Read More
Outlook desktop client is encrypting emails despite the sensitivity label setting
We have 3 different sensitivity labels set up – General, Internal and Confidential. The General label does not encrypt content, internal and confidential do. The default label for emails is Confidential.
When someone uses the Outlook Desktop client (release 2407) and switches from Confidential to General, the email is still encrypted. This doesn’t happen with the Outlook web client. If the switch from Confidential to Internal and then to General, the email is not encrypted.
Has anyone else seen this behavior?
We have 3 different sensitivity labels set up – General, Internal and Confidential. The General label does not encrypt content, internal and confidential do. The default label for emails is Confidential. When someone uses the Outlook Desktop client (release 2407) and switches from Confidential to General, the email is still encrypted. This doesn’t happen with the Outlook web client. If the switch from Confidential to Internal and then to General, the email is not encrypted. Has anyone else seen this behavior? Read More
New Outlook: Mark as Read Not working when filtered by Unread
When scrolling through the preview of messages filtered as unread the message is not marked as read. when openend in preview.
Works when I do not have the filter active.
When scrolling through the preview of messages filtered as unread the message is not marked as read. when openend in preview. Works when I do not have the filter active. Read More
People contacts vanished
All my people contacts vanished my email provider is shaw.ca
All my people contacts vanished my email provider is shaw.ca Read More
Bookings Report Automation?
Here it is, August of 2024. We have multiple ai engines in existence. We have reusable space rockets. We have advanced robotics. We have VR headsets. What do we not have? An update to Microsoft Bookings reporting capabilities.
I’m in a government account environment, so Power Automate isn’t an option. MS Graph isn’t an option. We’re still operating off of a 2018 solution, an Excel connection to Online Exchange for reporting. We’re unable to access custom field data without manually running the .tsv report out of our 18 Bookings pages. Even doing so, the custom field entries are lumped into a single column. I’ve opened a support ticket to Microsoft inquiring if there is a better way to access custom field data. Microsoft’s answer was “no.”
Has anyone else out there figured out a workaround to automate access to custom field data in government account environments?
Here it is, August of 2024. We have multiple ai engines in existence. We have reusable space rockets. We have advanced robotics. We have VR headsets. What do we not have? An update to Microsoft Bookings reporting capabilities. I’m in a government account environment, so Power Automate isn’t an option. MS Graph isn’t an option. We’re still operating off of a 2018 solution, an Excel connection to Online Exchange for reporting. We’re unable to access custom field data without manually running the .tsv report out of our 18 Bookings pages. Even doing so, the custom field entries are lumped into a single column. I’ve opened a support ticket to Microsoft inquiring if there is a better way to access custom field data. Microsoft’s answer was “no.” Has anyone else out there figured out a workaround to automate access to custom field data in government account environments? Read More
How to make an individual cell change red or green based on value in the cell
As you can see here i have the percents of made putts displayed next to the pro average and scratch golfers percents. I would like to turn the cells green or red based on if they are equal or greater to the scratch golfers.
As you can see here i have the percents of made putts displayed next to the pro average and scratch golfers percents. I would like to turn the cells green or red based on if they are equal or greater to the scratch golfers. Read More
COUNTIFS returns #VALUE!. Each of the criteria works in its countif. Reason: compare span 2 cols.
Hi: I have a COUNTIFS return #VALUE! when each of the 2 criteria would work in a COUNTIF on its own.
So, =COUNTIF($B$6:$C$33,”Apple”) and =COUNTIF($D$6:$D$33,”US”) both work on their own each return the count of rows satisfy the condition.
But if I combine the 2 criteria in a =COUNTIFS($B$6:$C$33,”Apple”,$D$6:$D$33,”US”), this will return #VALUE!
I’ve debugged and found is the criteria spanned 2 columns. If I adjust to only search within 1 column, the countifs works.
So, changing from:
=COUNTIFS($B$6:$C$33,”Apple”,$D$6:$D$33,”US”)
to:
=COUNTIFS($B$6:$B$33,”Apple”,$D$6:$D$33,”US”)
now works. So, I need to combine my Col B and Col C into a consolidated Column.
Wanted to check, is this by design? thnx –LC
I have MS 365 Apps for enterprise.
Hi: I have a COUNTIFS return #VALUE! when each of the 2 criteria would work in a COUNTIF on its own.So, =COUNTIF($B$6:$C$33,”Apple”) and =COUNTIF($D$6:$D$33,”US”) both work on their own each return the count of rows satisfy the condition.But if I combine the 2 criteria in a =COUNTIFS($B$6:$C$33,”Apple”,$D$6:$D$33,”US”), this will return #VALUE! I’ve debugged and found is the criteria spanned 2 columns. If I adjust to only search within 1 column, the countifs works.So, changing from:=COUNTIFS($B$6:$C$33,”Apple”,$D$6:$D$33,”US”)to:=COUNTIFS($B$6:$B$33,”Apple”,$D$6:$D$33,”US”)now works. So, I need to combine my Col B and Col C into a consolidated Column. Wanted to check, is this by design? thnx –LCI have MS 365 Apps for enterprise. Read More
To find the Missing rows
Every CEO should have both ‘SEYT’ and ‘ZZZZ’ records in Acc_Personal. I want to find any CEO record if anyone is missing ‘ZZZZ’ record. See table below.
CREATE TABLE DBO.TMP (CEO VARCHAR(20), Acc_Personal VARCHAR(20), AMT INT, DATEA DATETIME, STAT VARCHAR(1))
INSERT INTO DBO.TMP VALUES (‘10001′,’SEYT’,78, ‘2024-04-09′,’N’
INSERT INTO DBO.TMP VALUES (‘10001′,’ZZZZ’,12, ‘2024-03-09′,’N’
INSERT INTO DBO.TMP VALUES (‘10002′,’SEYT’,45, ‘2024-06-02′,’N’
INSERT INTO DBO.TMP VALUES (‘10002′,’ZZZZ’,55, ‘2024-07-07′,’D’
INSERT INTO DBO.TMP VALUES (‘10003′,’SEYT’,76, ‘2024-08-09′,’N’
INSERT INTO DBO.TMP VALUES (‘10004′,’SEYT’,45, ‘2024-04-02′,’C’
INSERT INTO DBO.TMP VALUES (‘10004′,’ZZZZ’,21, ‘2024-07-09′,’N’
INSERT INTO DBO.TMP VALUES (‘10005′,’SEYT’,57, ‘2024-04-01′,’N’
INSERT INTO DBO.TMP VALUES (‘10006′,’SEYT’,59, ‘2024-04-01′,’B’
INSERT INTO DBO.TMP VALUES (‘10006′,’SEYT’,47, ‘2024-02-01′,’A’
INSERT INTO DBO.TMP VALUES (‘10007′,’SEYT’,59, ‘2024-04-09′,’N’
Desired Output
—————–
CEO Acc_personal AMT DATEA STAT
1003
1005
1007
Every CEO should have both ‘SEYT’ and ‘ZZZZ’ records in Acc_Personal. I want to find any CEO record if anyone is missing ‘ZZZZ’ record. See table below. CREATE TABLE DBO.TMP (CEO VARCHAR(20), Acc_Personal VARCHAR(20), AMT INT, DATEA DATETIME, STAT VARCHAR(1)) INSERT INTO DBO.TMP VALUES (‘10001′,’SEYT’,78, ‘2024-04-09’,’N’INSERT INTO DBO.TMP VALUES (‘10001′,’ZZZZ’,12, ‘2024-03-09’,’N’INSERT INTO DBO.TMP VALUES (‘10002′,’SEYT’,45, ‘2024-06-02’,’N’INSERT INTO DBO.TMP VALUES (‘10002′,’ZZZZ’,55, ‘2024-07-07’,’D’INSERT INTO DBO.TMP VALUES (‘10003′,’SEYT’,76, ‘2024-08-09’,’N’INSERT INTO DBO.TMP VALUES (‘10004′,’SEYT’,45, ‘2024-04-02’,’C’INSERT INTO DBO.TMP VALUES (‘10004′,’ZZZZ’,21, ‘2024-07-09’,’N’INSERT INTO DBO.TMP VALUES (‘10005′,’SEYT’,57, ‘2024-04-01’,’N’INSERT INTO DBO.TMP VALUES (‘10006′,’SEYT’,59, ‘2024-04-01’,’B’INSERT INTO DBO.TMP VALUES (‘10006′,’SEYT’,47, ‘2024-02-01’,’A’INSERT INTO DBO.TMP VALUES (‘10007′,’SEYT’,59, ‘2024-04-09′,’N’ Desired Output—————–CEO Acc_personal AMT DATEA STAT100310051007 Read More
Microsoft 365 and Microsoft Office 2024 LTSC support on Windows Server 2025
For now, it is not clear if Microsoft 365 apps shall be supported on Windows Server 2025, at least during the mainstream support of the OS, although earlier there statements that said that they will be supported.
Microsoft Office 2024 LTSC does not include Windows Server 2025 as a supported OS. Would this mean it shall not be installable? Perhaps a the limited Microsoft 365 model shall be applied? I am interested in having office apps installed for offline use, on demand, on Windows Server 2025. Are there any clear and recent information on this topic?
For now, it is not clear if Microsoft 365 apps shall be supported on Windows Server 2025, at least during the mainstream support of the OS, although earlier there statements that said that they will be supported.Microsoft Office 2024 LTSC does not include Windows Server 2025 as a supported OS. Would this mean it shall not be installable? Perhaps a the limited Microsoft 365 model shall be applied? I am interested in having office apps installed for offline use, on demand, on Windows Server 2025. Are there any clear and recent information on this topic? Read More
Having partial text in a cell change to bold.
I’m trying to have Excel bold the text after “MM ” in a cell. I would like to have it do this for the entire range. Right now I’m doing it manually. Here is an image of my worksheet.
Any help would be appreciated.
Thank you.
Scott
I’m trying to have Excel bold the text after “MM ” in a cell. I would like to have it do this for the entire range. Right now I’m doing it manually. Here is an image of my worksheet.Any help would be appreciated.Thank you.Scott Read More
Number format problem for large amounts of tim
I have a table with per line; Article (text), Quantity (integer or default value), unit time (in hours and minutes), total time (in number of months, number of days, number of hours, and number of minutes). The unit time can be 1 min, 5 min, 1 hour, 3 hours or 8 hours (1 table line per unit time quantity). The total time of the line is equal to the quantity multiplied by the unit time. Of course, at the bottom of the column, I add the total sum of all time totals for each line. The problem that arises concerns the format of the numbers for the time totals. It’s one of two things.
If my total time is greater than 31 days and I have used a customized format without the number of months, the number of days displayed will be equal to the number of days exceeding the number of full months (for example, if my total is 33 days, the number of days displayed will be 2 (2 days beyond the 31-day month).
If this is not the case, there are two possible outcomes:
– If my customized format includes the number of months, the number of months is automatically set to 1, even if the cumulative time of my line is only one minute. Furthermore, if the accumulated time exceeds 1 month by even one minute, the number of months displayed will be 2, and so on.
– If my cumulative time is greater than 31 days and I’ve used a custom format without the number of months, the number of days displayed will be equal to the number of days exceeding the number of full months (e.g. if my total is 33 days, the number of days displayed will be 2 (2 days beyond the 31-day month).
Hence my question: Is there a simple way of solving this problem?
I have a table with per line; Article (text), Quantity (integer or default value), unit time (in hours and minutes), total time (in number of months, number of days, number of hours, and number of minutes). The unit time can be 1 min, 5 min, 1 hour, 3 hours or 8 hours (1 table line per unit time quantity). The total time of the line is equal to the quantity multiplied by the unit time. Of course, at the bottom of the column, I add the total sum of all time totals for each line. The problem that arises concerns the format of the numbers for the time totals. It’s one of two things. If my total time is greater than 31 days and I have used a customized format without the number of months, the number of days displayed will be equal to the number of days exceeding the number of full months (for example, if my total is 33 days, the number of days displayed will be 2 (2 days beyond the 31-day month). If this is not the case, there are two possible outcomes:- If my customized format includes the number of months, the number of months is automatically set to 1, even if the cumulative time of my line is only one minute. Furthermore, if the accumulated time exceeds 1 month by even one minute, the number of months displayed will be 2, and so on.- If my cumulative time is greater than 31 days and I’ve used a custom format without the number of months, the number of days displayed will be equal to the number of days exceeding the number of full months (e.g. if my total is 33 days, the number of days displayed will be 2 (2 days beyond the 31-day month). Hence my question: Is there a simple way of solving this problem? Read More