Tag Archives: microsoft
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
Help to find in sequence issue in groups records
Hi, Every group_cost has different sequence of PP_Seq but it should not be any gap in the sequence of any group_cost rcords. It should always be increment by 1. I want to see any record/row of any group_cost if it has any issue in pp_seq and not increment by 1. I want to see when the issue of sequence is started then it will be corrected with other next rows.
Create table #Cost (group_cost char(10), PP_Seq int, date1 datetime, ST char(2))
insert into #cost (‘T1′,5,’2023-01-01′,’A’)
insert into #cost (‘T1′,6,’2023-02-01′,’A’)
insert into #cost (‘T1′,7,’2023-03-01′,’A’)
insert into #cost (‘T2′,12,’2023-01-01′,’A’)
insert into #cost (‘T2′,14,’2023-02-01′,’B’) — This pp_seq is not increment by 1. Should be in output
insert into #cost (‘T2′,15,’2023-03-01′,’A’)
insert into #cost (‘T3′,25,’2023-01-02′,’A’)
insert into #cost (‘T3′,26,’2023-02-01′,’A’)
insert into #cost (‘T3′,27,’2023-03-05′,’A’)
insert into #cost (‘T5′,65,’2023-01-01′,’A’)
insert into #cost (‘T5′,66,’2023-02-06′,’A’)
insert into #cost (‘T5′,67,’2023-03-04′,’W’)
insert into #cost (‘T5′,69,’2023-04-01′,’A’) — This pp_seq is not increment by 1. Should be in output
–Expected result
group_cost PP_Seq date1 ST Comments
T2 14 2023-02-01 B PP_Seq is not in seq. Also check next rows to correct.
T5 69 2023-04-01 A PP_Seq is not in seq. Also check next rows to correct.
Hi, Every group_cost has different sequence of PP_Seq but it should not be any gap in the sequence of any group_cost rcords. It should always be increment by 1. I want to see any record/row of any group_cost if it has any issue in pp_seq and not increment by 1. I want to see when the issue of sequence is started then it will be corrected with other next rows. Create table #Cost (group_cost char(10), PP_Seq int, date1 datetime, ST char(2))insert into #cost (‘T1′,5,’2023-01-01′,’A’)insert into #cost (‘T1′,6,’2023-02-01′,’A’)insert into #cost (‘T1′,7,’2023-03-01′,’A’) insert into #cost (‘T2′,12,’2023-01-01′,’A’)insert into #cost (‘T2′,14,’2023-02-01′,’B’) — This pp_seq is not increment by 1. Should be in output insert into #cost (‘T2′,15,’2023-03-01′,’A’) insert into #cost (‘T3′,25,’2023-01-02′,’A’)insert into #cost (‘T3′,26,’2023-02-01′,’A’)insert into #cost (‘T3′,27,’2023-03-05′,’A’) insert into #cost (‘T5′,65,’2023-01-01′,’A’)insert into #cost (‘T5′,66,’2023-02-06′,’A’)insert into #cost (‘T5′,67,’2023-03-04′,’W’)insert into #cost (‘T5′,69,’2023-04-01′,’A’) — This pp_seq is not increment by 1. Should be in output –Expected resultgroup_cost PP_Seq date1 ST CommentsT2 14 2023-02-01 B PP_Seq is not in seq. Also check next rows to correct. T5 69 2023-04-01 A PP_Seq is not in seq. Also check next rows to correct. Read More
sharepoint dlp policies not detecting pdf files with label
Hello Everyone,
I have a Microsoft purview sharepoint DLP policy with a following condition.
I have targeted this to sharepoint online workload and specific site. I have labeled a file using Microsoft purview information protection client in windows explorer and same has been uploaded to sharepoint site(that is in scope of the policy). whenever I am trying to share the pdf file labeled with (confidential / All users encrypted) it is not getting blocked.
Please let me know if I am missing something related to sharepoint.
Note: There is no encryption settings in label, it is just a name.
Notify users with email and policy tips
Restrict access to the content for external users
Send alerts to Administrator
Hello Everyone, I have a Microsoft purview sharepoint DLP policy with a following condition. I have targeted this to sharepoint online workload and specific site. I have labeled a file using Microsoft purview information protection client in windows explorer and same has been uploaded to sharepoint site(that is in scope of the policy). whenever I am trying to share the pdf file labeled with (confidential / All users encrypted) it is not getting blocked.Please let me know if I am missing something related to sharepoint. Note: There is no encryption settings in label, it is just a name. ConditionsContent contains any of these sensitive info types: U.S. Social Security Number (SSN), Credit Card Number, Content contains any of these sensitivity labels: Confidential/All Users (Encrypted)Evaluate predicate for Message or attachmentAndContent is shared from Microsoft 365 with people outside my organizationActionsNotify users with email and policy tipsRestrict access to the content for external usersSend alerts to AdministratorOn Read More
Transferring Your Azure Subscription to a New Microsoft Entra ID
Could FastTrack assist in the scenario of Transferring an Azure Subscription to a New Microsoft Entra ID
Could FastTrack assist in the scenario of Transferring an Azure Subscription to a New Microsoft Entra ID Read More
