Category: Microsoft
Category Archives: Microsoft
Monitor and Notify Security Changes on a Team
We have a couple of teams that are only for executive team members. Is there a way I can monitor security changes within a Team? It could be a Power Automate or use other tools.
We have a couple of teams that are only for executive team members. Is there a way I can monitor security changes within a Team? It could be a Power Automate or use other tools. Read More
Sort data in PowerPoint table – Feature Request
Sorting tabular data is available in:
ExcelWord (Layout > Data > Sort)Outlook (Layout > Data > Sort)OneNote (Table > Data > Sort)
But not in PowerPoint? Surely this can be added to PowerPoint?
Sorting tabular data is available in:ExcelWord (Layout > Data > Sort)Outlook (Layout > Data > Sort)OneNote (Table > Data > Sort)But not in PowerPoint? Surely this can be added to PowerPoint? Read More
Migration Tool Access and moving old videos
We noticed some of our videos hadn’t been moved yet and went to try and fix it via the migration tool and we don’t seem to be able to do so now.
Is the tool decommissioned already and and is there anything we can do?
We noticed some of our videos hadn’t been moved yet and went to try and fix it via the migration tool and we don’t seem to be able to do so now. Is the tool decommissioned already and and is there anything we can do? Read More
Please clarify, applies to Microsoft Defender Application Guard (MDAG)
Microsoft Defender Application Guard (MDAG) is still recommended in Microsoft Edge for web browsing protection.
Is it an outdated app or should it be discontinued for Windows11?
Microsoft Edge and Microsoft Defender Application Guard | Microsoft Learn
Why is it possible to run in the latest version of Windows11?
Microsoft Defender Application Guard (MDAG) is still recommended in Microsoft Edge for web browsing protection.Is it an outdated app or should it be discontinued for Windows11?Microsoft Edge and Microsoft Defender Application Guard | Microsoft LearnWhy is it possible to run in the latest version of Windows11? Read More
Power Query for Mac using array as data source
Its not obvious to me how to connect an array as the data source for my Power Query on Mac. I have seen some videos that show connecting to Ranges and Tables using a PC.
Its not obvious to me how to connect an array as the data source for my Power Query on Mac. I have seen some videos that show connecting to Ranges and Tables using a PC. Read More
Copilot and Mac
Before I spend the subscription fee for Copilot, will it work on the Mac Version of Office 365?
The only add-in option I see when I search for Copilot is R2 Copilot: Private ChatGPT
I am wanting to use it to help create powerpoint presentations from word documents, I have seen some really great videos on this. But they are always on a Windows Operating System.
Can I do this on a MacBook Pro running macOS 15?
thanks.
Before I spend the subscription fee for Copilot, will it work on the Mac Version of Office 365? The only add-in option I see when I search for Copilot is R2 Copilot: Private ChatGPT I am wanting to use it to help create powerpoint presentations from word documents, I have seen some really great videos on this. But they are always on a Windows Operating System. Can I do this on a MacBook Pro running macOS 15? thanks. Read More
select some staff but others are required
I would like to create bookings where customers can select certain staff, but have other staff always guaranteed to be assigned.
For example:
Operations Request Meeting
Staff:
Operations Manager
Ops staff 1
Ops staff 2
Ops staff 3
Where someone can select one of the staff members, but the Manager is always assigned to the booking
Is this possible?
I would like to create bookings where customers can select certain staff, but have other staff always guaranteed to be assigned.For example: Operations Request MeetingStaff:Operations ManagerOps staff 1Ops staff 2Ops staff 3 Where someone can select one of the staff members, but the Manager is always assigned to the booking Is this possible? Read More
public booking pages will not load for non-office users
Clients attempting to book time with me using the Bookings page are receiving this error when they click the public link:
UTC Date: 2024-08-29T14:28:44.800Z
Client Id: 2
Session Id:
BootResult: retry
Back Filled Errors: Unhandled Rejection: SyntaxError: The string did not match the expected pattern.:undefinedlUnhandled Rejec
err: Microsoft.Exchange.Clients.Owa2.Server.Core.OwaUserHasNoMailboxAndNoLicenseAssignedException
esrc: StartupData
et: ServerError
estack:
st: 500
ehk: X-OWA-Error
efe: DS7P222CA0023, SA9PR11CA0021
ebe: DM8PR01MB6933
emsg: UserHasNoMailboxAndNoLicenseAssignedError
How do I resolve this so outside users can use the link to book?
Clients attempting to book time with me using the Bookings page are receiving this error when they click the public link: UTC Date: 2024-08-29T14:28:44.800ZClient Id: 2Session Id:BootResult: retryBack Filled Errors: Unhandled Rejection: SyntaxError: The string did not match the expected pattern.:undefinedlUnhandled Rejecerr: Microsoft.Exchange.Clients.Owa2.Server.Core.OwaUserHasNoMailboxAndNoLicenseAssignedExceptionesrc: StartupDataet: ServerErrorestack:st: 500ehk: X-OWA-Errorefe: DS7P222CA0023, SA9PR11CA0021ebe: DM8PR01MB6933emsg: UserHasNoMailboxAndNoLicenseAssignedError How do I resolve this so outside users can use the link to book? Read More
Formula Help for a tally
Looking for quick help creating a formula.
What I’m working with is going to be a long table with up to 30 names that’ll be repeating often. They can also have a specific number (employee number) attached to each one, to accommodate for any misspellings. Is there a formula that can calculate how many times the name/number appears? Like, 34678 shows up 34 times in Column A, and the result is put into another table/sheet, or just displayed after setting the formula into a cell? The goal is just that, quickly identify how many times it repeats.
Thanks!
Looking for quick help creating a formula.What I’m working with is going to be a long table with up to 30 names that’ll be repeating often. They can also have a specific number (employee number) attached to each one, to accommodate for any misspellings. Is there a formula that can calculate how many times the name/number appears? Like, 34678 shows up 34 times in Column A, and the result is put into another table/sheet, or just displayed after setting the formula into a cell? The goal is just that, quickly identify how many times it repeats.Thanks! Read More
Forms in Libraries
Hi,
I hope this is the right place to post this. If not please redirect me.
I currently have a system to create customer quotes using sharepoint lists, power automate, and a sharepoint library. The user goes to the list and creates a new entry by clicking new, then fills out the form with all the information. When they click save a “Flow” starts that gets the item properties from the newly created list item, then gets a content type template (word doc with quickparts) from a sharepoint library, then populates the template with the item properties and saves a copy in the library.
My question is this: Why do I need a list and a library to do this? Could I not do this all within one library and different views? I would like to have the user go to the library and click new, then select the document type, then fill out a form, and sharepoint would create a document from the content type template with all of the form data filled out.
I have got most of the way there but am running into a few problems:
1. When you select “new document” the new document opens in Word. I want a form to open instead.
2. When I proceed with filling out the properties in Word and then try to save the document, it wants to “save as” and prompts for a new location. I want it save to the library.
Hi,I hope this is the right place to post this. If not please redirect me. I currently have a system to create customer quotes using sharepoint lists, power automate, and a sharepoint library. The user goes to the list and creates a new entry by clicking new, then fills out the form with all the information. When they click save a “Flow” starts that gets the item properties from the newly created list item, then gets a content type template (word doc with quickparts) from a sharepoint library, then populates the template with the item properties and saves a copy in the library. My question is this: Why do I need a list and a library to do this? Could I not do this all within one library and different views? I would like to have the user go to the library and click new, then select the document type, then fill out a form, and sharepoint would create a document from the content type template with all of the form data filled out.I have got most of the way there but am running into a few problems:1. When you select “new document” the new document opens in Word. I want a form to open instead.2. When I proceed with filling out the properties in Word and then try to save the document, it wants to “save as” and prompts for a new location. I want it save to the library. Read More
August V2 Title Plan now available!
Don’t forget to checkout updates made to the Title Plan, shared in its permanent location, linked above.
Please note: This is not a support forum. Only comments related to this specific blog post content are permitted and responded to.
For ILT Courseware Support, please visit: aka.ms/ILTSupport
If you have ILT questions not related to this blog post, please reach out to your program for support.
Microsoft Tech Community – Latest Blogs –Read More
Introducing granular permissions for Azure Service Bus Explorer
When working with the Service Bus Explorer in the Azure portal, you may want to grant different permissions to different users, depending on their role and responsibility. For example, you may want to allow some users to send messages to a queue, but not receive them. Or you may want to restrict access to a specific queue, topic, or subscription, but not the entire namespace.
To address this challenge, we are excited to announce granular permissions for Service Bus Explorer. To use granular permissions, you need to use Microsoft Entra authentication, and assign one of the following roles, either on the namespace level or on the entity level.
Service Bus Data Owner; Allows to execute both send and receive operations.
Service Bus Data Sender; Allows to execute send operations.
Service Bus Data Receiver; Allows to execute peek, receive, and purge operations.
In case you use a role which doesn’t have send or receive permissions, or you do not have permissions on the specific entity, the unavailable operations will be disabled. Furthermore, a notification will be shown showing which permissions are missing.
For more information on using the Service Bus Explorer, you can check our documentation.
Microsoft Tech Community – Latest Blogs –Read More
Partner Blog | Unlocking growth: leveraging Microsoft tools for growing your migration practice
By Pankaj Srivastava, General Manager, Azure Partner Sales & Strategy
In today’s dynamic digital landscape, staying relevant means continuously adapting and using the best tools available. For partners focused on building their migration practice, Microsoft offers a unique opportunity to grow their business with a robust suite of resources and offers designed to streamline migration processes, enhance operational efficiency, and drive growth. In this blog, we discuss how you can best use these assets to enhance your services and drive success.
Generate customer interest and demand
Start by accessing Microsoft CloudAscent customer propensity lists in Partner Center to identify migration and security opportunities within the SMB sector. These lists help you target the right customers for your services. For managed partners, your PDM can download additional Enterprise and SMC-C migration propensity lists, providing key information about each account where you are the incumbent. These lists include Windows Server end-of-support (EOS) opportunity flags, SQL Server EOS flags, Microsoft Defender for Cloud consumption flags, and whether an assessment has been done on the account.
Next, use the campaign in a box assets and scripted campaigns to drive demand for Azure VMware Services (AVS) and Windows Server/SQL Server migrations. These resources are crafted to help you effectively market your services and attract new clients with updated content and messaging from our marketing experts; while also helping you position your company value front and center.
Whether you need ready-to-share Digital Marketing Content OnDemand (DMC) or customizable campaigns from the Partner Marketing Center (PMC), we have assets to help you.
Digital Marketing Content OnDemand (DMC) scripted campaigns:
Migrate and Secure Windows Server and SQL Server SMB
Migrate and Secure Windows Server and SQL Server ENT
Migrate VMware Workloads to Azure
Partner Marketing Center (PMC) downloadable campaign content:
Migrate and Secure Windows Server and SQL Server SMB
Migrate and Secure Windows Server and SQL Server ENT
Migrate VMware workloads to Azure
Continue reading here
Microsoft Tech Community – Latest Blogs –Read More
Random Pool Generator excel office 365
Im trying to create a quiz generator. I have an excel file with 49 worksheets, and each worksheet covers one topic area and has a group of 20 or so related questions. Some groups have more questions, some less. I could make the worksheets into one big sheet if required, and just create a column to label each related topic area.
i want to create 30 randomly generated questions from that pool, with no more than two from any one topic area. Ive got a few ideas but nothing that seems relatively simple.
looking for formula based solution – not macro based.
TIA!
Im trying to create a quiz generator. I have an excel file with 49 worksheets, and each worksheet covers one topic area and has a group of 20 or so related questions. Some groups have more questions, some less. I could make the worksheets into one big sheet if required, and just create a column to label each related topic area.i want to create 30 randomly generated questions from that pool, with no more than two from any one topic area. Ive got a few ideas but nothing that seems relatively simple. looking for formula based solution – not macro based. TIA! Read More
Planner Premium unavailable in Power Automate
I was very happy to be able to start with Planner Premium. But … what did I experience? Power Automate doesn’t see the Planner Premium so I am unable to import activities from Monday.Com planning. There is also no import facility. How does Microsoft support customers to convert old plans to Planner Premium?
I was very happy to be able to start with Planner Premium. But … what did I experience? Power Automate doesn’t see the Planner Premium so I am unable to import activities from Monday.Com planning. There is also no import facility. How does Microsoft support customers to convert old plans to Planner Premium? Read More
Help reformatting schedule template
Hello, I like the look of the Excel “Student Schedule” template (it autopopulates into a weekly calendar view based on the “Class List” tab and highlights column for today’s day of week and row for current time/hour). I want to update this template to do a few things.
1. I won’t be using for class schedule but want to use to reserve vacant rooms in my office. So, I would change “Class Schedule” to “Vacant Room Availability” and Class List to “Sign-Up). (Changing names is simple, I can do that – but I’m not sure how it will affect formulas and conditioning that will need to be updated).
2. On the “Sign-Up” tab – I don’t need all the data in the original Class List tab. I only need ROOM (there are 2 rooms available), PERSON, DAY, START TIME, and END TIME.
-On the weekly calendar view (Vacant Room Availability tab aka Class Schedule), when you input data into a row on class list/sign-up tab – it highlights the cells according to the time duration and it has text from the “ID” column on the class list/sign-up tab. I want the text that is shown on the weekly view to be what’s under “Person” column to show John has room A from 1-2pm and Sally has room B from 8-9am.
3. I want to add dates to the sheets and I want the calendar view and sign-up/class list to update by week based on the date.
-Date could be easily added by adding a row above the named days of the week. So there can be a dedicated cell that has Sunday’s date for a given week then in the row above the words Sunday through Saturday, it will autopopulate the date for that day. When you change the date for the dedicated Sunday cell – it should update the rest of the dates above the days of the week… I’ve figured out how to do that but the issue now is making it dynamic so the weekly view “refreshes” so to speak to view corresponding bookings for that week.
-That would mean updating the Sign-Up/Class List tab to also include a cell dedicated to Sunday’s date for a given week. My hope is that when that date cell is updated the table in the Sign-Up/Class List tab will refresh. So let’s say there’s bookings in for this week 8/25/24 – that should autopopulate on weekly view. But if I change sign-up to 9/1/24 it should be blank since no bookings have been added and the weekly view should also be blank.
4. Since there are 2 different rooms that can be booked – I’m not sure if I need to copy/paste the tabs for room 2 or if they can be added on the same weekly calendar view. As is, the template only allows one highlight for a certain day/time based on data in the Class List tab. If I try to schedule 2 different things in the class list tab for Wednesday from 1-3pm – it doesn’t show both bookings.
Is there a way to show both rooms (in different colors) booked for the same day/time on the same weekly view – if so that is my preference.
If not, can I copy/paste and update the tabs for room 2 but have it in the same Excel file – how would formulas/conditionings need to be updated?
Sorry this is a lot of info and hopefully makes sense.
Hello, I like the look of the Excel “Student Schedule” template (it autopopulates into a weekly calendar view based on the “Class List” tab and highlights column for today’s day of week and row for current time/hour). I want to update this template to do a few things.1. I won’t be using for class schedule but want to use to reserve vacant rooms in my office. So, I would change “Class Schedule” to “Vacant Room Availability” and Class List to “Sign-Up). (Changing names is simple, I can do that – but I’m not sure how it will affect formulas and conditioning that will need to be updated).2. On the “Sign-Up” tab – I don’t need all the data in the original Class List tab. I only need ROOM (there are 2 rooms available), PERSON, DAY, START TIME, and END TIME.-On the weekly calendar view (Vacant Room Availability tab aka Class Schedule), when you input data into a row on class list/sign-up tab – it highlights the cells according to the time duration and it has text from the “ID” column on the class list/sign-up tab. I want the text that is shown on the weekly view to be what’s under “Person” column to show John has room A from 1-2pm and Sally has room B from 8-9am.3. I want to add dates to the sheets and I want the calendar view and sign-up/class list to update by week based on the date.-Date could be easily added by adding a row above the named days of the week. So there can be a dedicated cell that has Sunday’s date for a given week then in the row above the words Sunday through Saturday, it will autopopulate the date for that day. When you change the date for the dedicated Sunday cell – it should update the rest of the dates above the days of the week… I’ve figured out how to do that but the issue now is making it dynamic so the weekly view “refreshes” so to speak to view corresponding bookings for that week.-That would mean updating the Sign-Up/Class List tab to also include a cell dedicated to Sunday’s date for a given week. My hope is that when that date cell is updated the table in the Sign-Up/Class List tab will refresh. So let’s say there’s bookings in for this week 8/25/24 – that should autopopulate on weekly view. But if I change sign-up to 9/1/24 it should be blank since no bookings have been added and the weekly view should also be blank. 4. Since there are 2 different rooms that can be booked – I’m not sure if I need to copy/paste the tabs for room 2 or if they can be added on the same weekly calendar view. As is, the template only allows one highlight for a certain day/time based on data in the Class List tab. If I try to schedule 2 different things in the class list tab for Wednesday from 1-3pm – it doesn’t show both bookings. Is there a way to show both rooms (in different colors) booked for the same day/time on the same weekly view – if so that is my preference.If not, can I copy/paste and update the tabs for room 2 but have it in the same Excel file – how would formulas/conditionings need to be updated? Sorry this is a lot of info and hopefully makes sense. Read More
Is there a way to speed up this looped code
Hi all,
I have some code below that I am using to hide rows other than those with a specified value generated from a userform. The loop is super slow (took almost 30 minutes last night) and I am wondering how I can speed up the process. There won’t be 20k+ populated rows but the populated rows will grow over time. I am using such a large number to get more longevity out of the spreadsheet but in reality there may not be much more that 1 – 2k a year but even that will still take time to go through the loop.
I can build in something for users to purge resolved items but the # of populated rows, that aren’t resolved will still grow over time so I need to find a faster way of hiding unpopulated rows if possible.
I don’t want to use row filters because the worksheet is protected and I also need users to go through userforms to navigate the spreadsheet.
Any assistance would be appreciated.
Dim ws As Worksheet
Dim rng As Range
Dim cell As Range
‘ Set the worksheet
Set ws = ThisWorkbook.Sheets(“MAIN”)
‘ Set the range to the data range in Column H (adjust as needed)
Set rng = ws.Range(“R6:R20005”)
‘ Loop through each cell in the specified range
For Each cell In rng
If cell.Value <> CDate(courtdate) Then
‘ Toggle the row visibility
cell.EntireRow.Hidden = Not cell.EntireRow.Hidden
End If
Next cell
Hi all, I have some code below that I am using to hide rows other than those with a specified value generated from a userform. The loop is super slow (took almost 30 minutes last night) and I am wondering how I can speed up the process. There won’t be 20k+ populated rows but the populated rows will grow over time. I am using such a large number to get more longevity out of the spreadsheet but in reality there may not be much more that 1 – 2k a year but even that will still take time to go through the loop. I can build in something for users to purge resolved items but the # of populated rows, that aren’t resolved will still grow over time so I need to find a faster way of hiding unpopulated rows if possible. I don’t want to use row filters because the worksheet is protected and I also need users to go through userforms to navigate the spreadsheet. Any assistance would be appreciated. Dim ws As Worksheet
Dim rng As Range
Dim cell As Range
‘ Set the worksheet
Set ws = ThisWorkbook.Sheets(“MAIN”)
‘ Set the range to the data range in Column H (adjust as needed)
Set rng = ws.Range(“R6:R20005”)
‘ Loop through each cell in the specified range
For Each cell In rng
If cell.Value <> CDate(courtdate) Then
‘ Toggle the row visibility
cell.EntireRow.Hidden = Not cell.EntireRow.Hidden
End If
Next cell Read More
Improved user experience for Dictate in new Outlook for Windows and Outlook for the web
Hi, Microsoft 365 Insiders,
Outlook for Windows and the web just got even better!
The improved Dictate feature in the new Outlook for Windows and Outlook for the web is here to transform your email experience. With support for 50+ languages in Dictate, the new experience allows you to pause/resume dictation, adjust settings such as auto-punctuation and profanity filters, and access help articles with ease. Whether you’re drafting a quick email or a detailed message, Dictate makes it seamless.
Check out the full details in our new blog: Improved user experience for Dictate in new Outlook for Windows and Outlook for the web
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android
Hi, Microsoft 365 Insiders,
Outlook for Windows and the web just got even better!
The improved Dictate feature in the new Outlook for Windows and Outlook for the web is here to transform your email experience. With support for 50+ languages in Dictate, the new experience allows you to pause/resume dictation, adjust settings such as auto-punctuation and profanity filters, and access help articles with ease. Whether you’re drafting a quick email or a detailed message, Dictate makes it seamless.
Check out the full details in our new blog: Improved user experience for Dictate in new Outlook for Windows and Outlook for the web
Thanks!
Perry Sjogren
Microsoft 365 Insider Community Manager
Become a Microsoft 365 Insider and gain exclusive access to new features and help shape the future of Microsoft 365. Join Now: Windows | Mac | iOS | Android Read More
Conditional Access Policy Block Downloads (Preview)
Hello Community,
I’ve been encountering a challenging issue with implementing a Conditional Access (CA) policy to block downloads on unmanaged devices and could really use some insights.
Here’s the situation:
Objective: Block downloads for unmanaged devices using Conditional Access.Setup: I’ve replicated the policy setup across two tenants, ensuring that licenses and CA policies are identical.
Problem:
In one tenant, the policy works flawlessly.In the other tenant, users experience a timeout on the “Access to Microsoft SharePoint Online is monitored” screen. After this timeout, they are given the option to bypass Defender for Cloud Apps, which is not the desired outcome.
I’ve tried the following troubleshooting steps:
Removed all conditions to isolate the issue—no success.Ensured that the test user has no roles associated.
Despite these efforts, I’m still unable to get the policy to work correctly in the problematic tenant. The timeout and bypass options are a major concern, as they defeat the purpose of the policy.
Has anyone encountered this issue before, or does anyone have suggestions for resolving this?
Thanks in advance for your help!
Hello Community,I’ve been encountering a challenging issue with implementing a Conditional Access (CA) policy to block downloads on unmanaged devices and could really use some insights.Here’s the situation:Objective: Block downloads for unmanaged devices using Conditional Access.Setup: I’ve replicated the policy setup across two tenants, ensuring that licenses and CA policies are identical.Problem:In one tenant, the policy works flawlessly.In the other tenant, users experience a timeout on the “Access to Microsoft SharePoint Online is monitored” screen. After this timeout, they are given the option to bypass Defender for Cloud Apps, which is not the desired outcome.I’ve tried the following troubleshooting steps:Removed all conditions to isolate the issue—no success.Ensured that the test user has no roles associated.Despite these efforts, I’m still unable to get the policy to work correctly in the problematic tenant. The timeout and bypass options are a major concern, as they defeat the purpose of the policy.Has anyone encountered this issue before, or does anyone have suggestions for resolving this?Thanks in advance for your help! Read More
Connection error popup low virtual memory
Getting a strange error occasionally from the Azure Remote Desktop client for my customer. I don’t think it is really about virtual memory on the client computer, and it occurs before any connection is even attempted to the virtual machine. Using client version 1.2.5620.0 (x64). I can’t seem to produce the error on demand, so far when it has occurred, it has been following a recent disconnection, but it doesn’t do it every time. I’m not finding anything too relevant in the logs on the client machine or the diagnostic logging for the Azure resources.
Remote Desktop
This computer can’t connect to the remote computer.
The problem might be due to low virtual memory on your computer. Close your other programs, and then try connecting again. If the problem continues, contact your network administrator or technical support.
Joe
Getting a strange error occasionally from the Azure Remote Desktop client for my customer. I don’t think it is really about virtual memory on the client computer, and it occurs before any connection is even attempted to the virtual machine. Using client version 1.2.5620.0 (x64). I can’t seem to produce the error on demand, so far when it has occurred, it has been following a recent disconnection, but it doesn’t do it every time. I’m not finding anything too relevant in the logs on the client machine or the diagnostic logging for the Azure resources. Remote DesktopThis computer can’t connect to the remote computer.The problem might be due to low virtual memory on your computer. Close your other programs, and then try connecting again. If the problem continues, contact your network administrator or technical support. Joe Read More
