Category: Microsoft
Category Archives: Microsoft
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
Resize my Powerpoint Presentation
I am trying to resize my PPT and I was able to resize it in my previous file. I have a page of text from a book that is the basis of the page but the headings were corrupted so I added text boxes with new headings. I was able to make 3 new sizes of the PPT and it automatically adjusted the text box sizes and the fonts within it to the new size. Now when I try it the text box shrinks but the font stays the same size.
How can I shrink the whole page with multiple text boxes and fonts so that everything adjusts at once? Need assistance on this at the earliest possible!
I am trying to resize my PPT and I was able to resize it in my previous file. I have a page of text from a book that is the basis of the page but the headings were corrupted so I added text boxes with new headings. I was able to make 3 new sizes of the PPT and it automatically adjusted the text box sizes and the fonts within it to the new size. Now when I try it the text box shrinks but the font stays the same size. How can I shrink the whole page with multiple text boxes and fonts so that everything adjusts at once? Need assistance on this at the earliest possible! Read More
Recommendations to set up complex permissions site and library
We have a process in SP2016 where one collection has about 200 subsites and another similar collection about 50 subsites. Each subsite is for 1 user, some profile data, and their documents. A couple times a year a group of subsites need to have read access for three other employees (3 different per subsite, not 3 for the group of subsites). After about a month, these permissions are removed. This is a very manual process. This system needs to be converted to SPO, but subsites are not permitted and since the subsite template may change, does not seem appropriate. My process has been to create a record per user, linked to a folder per user and accessed via a PowerApp. I have some workflows to help manage permissions, but it’s not comprehensive yet. I’m interested in finding out how someone else would tackle this migration, keeping in mind that ultimately it is managed by non-tech HR staff. Thank You!
We have a process in SP2016 where one collection has about 200 subsites and another similar collection about 50 subsites. Each subsite is for 1 user, some profile data, and their documents. A couple times a year a group of subsites need to have read access for three other employees (3 different per subsite, not 3 for the group of subsites). After about a month, these permissions are removed. This is a very manual process. This system needs to be converted to SPO, but subsites are not permitted and since the subsite template may change, does not seem appropriate. My process has been to create a record per user, linked to a folder per user and accessed via a PowerApp. I have some workflows to help manage permissions, but it’s not comprehensive yet. I’m interested in finding out how someone else would tackle this migration, keeping in mind that ultimately it is managed by non-tech HR staff. Thank You! Read More
Exchange Hybrid to Exchange Online – AD Sync enabled
Hi All,
I have a scenario with two redudants exchanges 2019 onprem and Office 365.
All mailboxes are hosted in cloud and we are using no smtp in onprem server.
Is there a known process to proceed with decomm of onprem server? Does the Microsoft cover this process?
Just did some researches and AD Sync could be a issue to proceed with this migration.
Thanks in advance
Hi All,I have a scenario with two redudants exchanges 2019 onprem and Office 365.All mailboxes are hosted in cloud and we are using no smtp in onprem server. Is there a known process to proceed with decomm of onprem server? Does the Microsoft cover this process?Just did some researches and AD Sync could be a issue to proceed with this migration. Thanks in advance Read More
Comment Threshold using Question Responses Filter
Has anybody else run into this? I opened a ticket because comments were being suppressed even if there were 10+ respondents when using ‘Question Response’ filters. Our threshold is 10. The engineering team said that ‘Question Response’ threshold are always 20 for comments regardless thresholds set in configuration. Why would the threshold configuration work for some filters but not others?! I can’t find documentation either. Anyone else?
Has anybody else run into this? I opened a ticket because comments were being suppressed even if there were 10+ respondents when using ‘Question Response’ filters. Our threshold is 10. The engineering team said that ‘Question Response’ threshold are always 20 for comments regardless thresholds set in configuration. Why would the threshold configuration work for some filters but not others?! I can’t find documentation either. Anyone else? Read More