Recent Discussions
Footer Template Not Updating
I have 14 documents that need to have the same footer. This footer consists of three hyperlinks and a page number. When updates need to be made to one, all documents need to be updated. To do this, I created a footer template by selecting everything in the footer and then Save Selection to Footer Gallery. I then went to another document and was able to successfully add that footer. However, when I make a footer update (i.e. link or text change) on one of the documents, it doesn't update to the other 13. I tried selecting everything again and then Save Selection to Footer Gallery with the same name to overwrite it but the footer doesn't update where I've already added it. If I delete what was there and readd the footer, the updates will appear but it does not make sense to do that 13 different times. What am I doing wrong?
Question About OneDrive "Physical" Storage Location for Microsoft 365 Business Basic Plan
Dear Microsoft 365 Experts, I have a question. I recently signed up for a Microsoft 365 account with the "Microsoft 365 Business Basic" plan, where the domain name ends with "@onmicrosoft.ca" and I selected Canada as my home country. After creating this account, I was pleased to see that Microsoft Teams and Exchange Online are hosted in Canada. However, for OneDrive, the storage location is not specified. Why is the storage location not in Canada? I need to store my data in Canada for work-related compliance reasons. How can I change the OneDrive storage location to Canada? Thank you! Mike
Create table using LET based on column values
Hi all Hope you can help. I am trying to create an output table based on another tables column data. Example: Original Data Table: Task Target Group 1 Group 2 Group 3 Group 4 Task 1 10 5 10 Task 2 20 10 Task 3 10 5 15 16 Task 4 50 90 10 20 19 Output Table Desired: Tasks Team Result Task 1 Group 1 5 Task 1 Group 3 10 Task 2 Group 2 10 Task 3 Group 1 5 Task 3 Group 2 15 Task 3 Group 3 16 Task 4 Group 1 90 Task 4 Group 2 10 Task 4 Group 3 20 Task 4 Group 4 19 Any advice where to start please? Thanks
Issues with Sensitivity Labels and "Specific email addresses or domains" - Not working
Hello! We have enabled Sensitivity Labels in our tenant. The access control settings for the label states that a specific domain gets the permission "Co-Author". When we enable the Sensitivity label on a document and sent it towards the approved domain, it results in an error message when authenticating to open the document: "Selected user account does not exist in tenant 'Veni AS' and cannot access the application in that tenant. The account needs to be added as an external user in the tenant first. Please use a different account." After doing some research I did some changes to the external domain within the Cross-tenant settings. The external domain now has the following settings: Inbound access: Allow access on external users and groups, within B2B Collaboration Allow access on external users and groups, within B2B direct connect Trust multifactor authentication from Microsoft Entra tenants, within Trust settings. Outbound access: Allow access on users and groups, within B2B Collaboration Allow access on users and groups, within B2B direct connect External Identities: Block access for external users and groups. (Inherited from default) After doing this change, I no longer get the same error message as above when authenticating to open the labeled document. Now I get the following error message: "You are not signed in to office with an account that has permission to open this document. You may sign in a new account into Office that has permission or request permission from the content owner" I have this working from another tenant to the same external domain and I have cross-checked the settings. Any idea on how to proceed, or if it is any obvious change I need to make in order to get this to work? All feedback appreciated! :-)
Comments not displaying on hover
Hi, So I just got back from a stretch of leave to find that comments now only show the 'reply' option, but don't show the original comment or thread ... any idea how to fix this? Going to the menu option (review>show comments) and bringing up a sidebar is ridiculously cumbersome, especially for something that used to work. I have hundreds of comments in my tracker, so this is fairly annoying, and I'm hoping there's an option to have it display again.
Audit booking changes
Have users reporting long-standing discrepancies on room bookings - stuff being cancelled months ago, but not showing anywhere. I remember in the past, being able to audit this. Unfortunately, we now have Purview - a tool we didn't ask for, don't want, but allegedly are forced to use. These are Resources in 365, they have Exchange Mailboxes. Exchange has a tool to search for changes, but demands the subject line. The booking has been removed by the users - and I have no idea if this wants the original 'Booking' or the 'Re: Booking' or the 'FW: booking' or which of the 120 emails were generated. So I'm looking for alternative ways. I believe in the past, I did this via Defender. There WERE activities for Mailbox changes within this audit tool. They appear to be gone - or searching for Mailbox just removes all activities labeled 'Mailbox', I'm not sure. CoPilot gives me an evolving series of deprecated/possibly non-existent cmdlets for powershell, so that's fun. please do not refer me to another terrible marketing 'article'.. I have read so many, learned absolutely nothing useful, and I'm over it. Thank you
Formula Required if possible
Hi All, Can the following be accomplished… Help with a formula…. Sheet1 C8 and Sheet2 F7 Three alternative texts to choose from…. Sheet1 C8 – text entered “CASH” then Sheet2 F7 shows “CASH”. OR Sheet1 C8 – text entered “NIL” then Sheet2 F7 shows “NO PAYMENT”. OR Sheet1 C8 – text entered “EFT” then Sheet2 F7 shows “ELECTRONIC FUNDS TRANSFER (EFT)”Help with Excel report creation for review results from multiple worksheets...
Windows 11 MS Office 365 Cloud Accessed from Citrix desktop I've been working on this project for a while and have a tracking spreadsheet for several review categories, each on its own worksheet tab. I have a results page that gives me the data I need. The table on the RESULTS tab contains the results for the reviews and marks them as either having 'Not Met', 'Met' or 'Exceeded' the goal for each category. The final piece of the project is giving us problems. I received a great deal of help with it from @HansVodelaar here on the forum and he got very close to solving it. I've included the spreadsheet with the final attempted 'Result' tab. Here is what I'm trying to do now... Automatically generate a simple report Based on the generated date on 'RESULTS' for the selected Rep That lists all records, Labeled by review category (see review tabs), From the designated start date to designated end date, Only for the categories with scores designating them as either 'Not Met' or 'Exceeding' the goal. So far, the 'Report' tab works to list the records. However, there are a couple of problems with it. I can't seem to successfully copy the formula to the master workbook, which holds the same structure, but is not redacted. The returned data, as is, only separates the categories by a blank line, but does not identify to which review tabs (categories) the results belong. Any help offered is greatly appreciated. Hans suggested that the solution may require use of Power Query. So, if anyone has an idea of how I can accomplish this report without having to go into each tab to filter, sort, format and print, it would be totally awesome!!Unable to add group to Cloud Policy
For some reason I'm unable to add a group to more than one Cloud Policy. I created a new CP (for Word for example) and add my group without issue. Then I create another CP (for Excel) and then go to add that same group to the scope of this CP and I get this error message "There is already a policy configuration for the selected group. Either select a new security group or edit the existing one". This happens every time I try to add a group to more than one CP, previously this hadn't been an issue. Am I doing something wrong? Is there a way to fix this? Thanks, Jamie
Conditional Access App Control issues
I'm trying to create a Cloud App policy to detect and block logins to any of our cloud apps that are leveraging SSO with Entra from Tor or anonymous IP's. I read an article where you can use Conditional Access App Control to apply cloud app policies during login via Entra. I've created the initial CA policy (report only), applied to users, applied to specific cloud app, set to use Use Conditional Access App Control choosing "Use custom policy..." and logged onto the cloud app. I then check the users signin log and confirmed the CA rule was marked as success. Next I go to Defender portal, Cloud Apps, Policy management and try to create an access policy and I get this error: You don't have any apps deployed with Conditional Access App Control. Go to the Conditional Access App Control page to deploy an app. Missing a step?Issue with saving Macros Personal Macro Workbook in the startup folder must stay open for recording
Hi, I'm hoping one of the Excel gurus can assist me with this issue I am suddenly having with Macros. Suddenly all of the macros I had saved and have been using have dissappeared. I had these Macros set up in a tab and would just click the macro for the job I was running and it would format my document accordingly. As everyone knows, this saves a significant amount of time. Why this happened, I don't know. The only option now is to rebuild them. This is the process I'm doing to rebuild them: Developer tab Record Macro In Record Macro Box Name Macro Store macro in: Personal Macro Workbook Click: OK Error Message Returned: "Personal Macro Workbook in the startup folder must stay open for recording." I don't know how to get this Personal Macro Workbook to open. I thought that this workbook would automatically open at the start up of Excel. This glitch has caused me so much time and energy that it has actually put me behind in my work. I've checked the path and the "Personal.xlsb" file is in the XLSTART folder.Error in Microsoft 365 Admin Center Trying to Enable Teams for Organization
In the Microsoft 365 admin center, it says that "Teams is off for your organization". When I click that, I get an error: However, I believe I have teams setup since I can reach admins.teams.microsoft.com and manage things. The problem I am having is that no one from my organization can join a guest organization and I suspect it has something to do with microsoft 365 not being configured correctly.
Recent Blogs
- We are excited to announce that Microsoft 365 and the Microsoft 365 Advanced Data Residency add-on (ADR) are now available for commercial customers in our new cloud region in Chile.Jun 18, 2025
- Copilot in Excel now intelligently infers the relevant table or data range based on your query, enhancing usability. Additionally, it visually highlights the inferred data for clarity.Jun 18, 2025
