Recent Discussions
Need to Restore PST Files to Office 365 Mailboxes - What's the Best Approach
Hey everyone, I have a task coming up where I need to restore several PST files back into Office 365 mailboxes. Haven't done this before at this scale and honestly not sure where to begin. I've looked at Microsoft's native import service through Purview but I have a few concerns: Some of the PST files are quite large — not sure how well it handles that I need to restore only specific folders for some users, not the entire PST I'm worried about data consistency after the restore Would prefer something that doesn't require too many admin roles or complex setup For those who have done PST to Office 365 restores — what approach worked best for you? Any tools, tips, or things to watch out for that you wish you knew before starting?98Views0likes3CommentsAccess and SharePoint Integration May Be Broken
I am posting this here in the hopes that a Microsoft MVP or employee may see it, verify the issue, and report it to the right people at Microsoft. We have a fairly significant LOB application with the front-end hosted in Access and the back-end hosted in SharePoint Online lists. This application has been working well for several years. Sometime in the past few weeks (last known good date was June 23), a change in either Access or SharePoint (or maybe the Windows OneDrive sync client) seems to have broken integration between the products. When the modern cache format is enabled (the default), all SharePoint calculated columns unexpectedly show errors, as shown here (in a fresh database where I imported just one list from our site as a test): Naturally, this completely borks the application, with VB code throwing errors at startup. Using the legacy cache format, or disabling caching altogether, seems to restore functionality--(though this would come at a cost to performance): But there is a major caveat to this. Other functionality is apparently broken. We have straightforward update queries, for example, the hang indefinitely in these modes, rendering this an unacceptable work-around. I have been able to replicate this on several different PCs. Also, on several different SharePoint sites in our tenant. Currently, this is blocking work for us, and we are hoping to see it resolved as soon as possible. If anyone with knowledge of the right people at Microsoft to call attention to this, we would be grateful for any help. I am using the Access forum because the last time I tried to get help from SharePoint Online support for an Access-related query issue using SP list data, they had no idea what I was talking about. (Also, for Access database experts: please do not suggest that we avoid using calculated columns in SharePoint lists. This is a hybrid app with most of our users working with data strictly through SharePoint, and SharePoint views do not support the same features as queries do in Access. Making use of these SharePoint features are essential for these users.) Our Access version: Microsoft® Access® for Microsoft 365 MSO (Version 2607 Build 16.0.20228.20124) 64-bit Thank you in advance for any help.173Views0likes6CommentsError message to say can't install add-ins (where ones I have stop appearing on toolbar)
Hi, I have an accountancy add-in for Excel which normally appears on my toolbar when I load Excel up. For some reason it wasn't there all of a sudden so tried to load it again as an add-in but just get an error message at the bottom of the screen to say that it can't be loaded and to try again later. Tried chatting with Microsoft Support who were no help at all and tried to blame it on the third party software not Excel until I tried loading other add-ins (including Microsoft ones) and get exactly the same message. Tried logging in and out of my account and shutting down and re-starting but to no avail. Any ideas/solutions would be most welcome! Thanks, David21Views0likes1CommentAdd-ins not working
Hi team, I am unable to use Add-ins. I have used two AI chatbots to troubleshoot and understand the issue, and I spoke to two Microsoft support people, the second of whom advised me to raise the issue here. I believe it to be a server-side issue as I tried to use https://marketplace.microsoft.com/en-gb/ to re-install the add-in that I need, and the first few times I tried I got a 502 bad gateway error. However, I now don't get this error but the problem still isn't solved as I can't use add-ins. I tried using my PC-installed copies of Word and Excel to use add-ins, and the online Word platform, and I get the same error every time - "We couldn't connect to the '{0}' catalog server". For a while I thought the issue might be because my country was incorrectly set to the US but I eventually managed to change it to the UK and the problem is not solved. I have troubleshot a range of solutions including to do with my internet connection and VPN - these don't seem to be the problem. Please help. Best wishes.29Views1like3CommentsMS will not properly investigate breaches of security. What can I do?
I cannot accurately describe the innumerable ways in which these breaches of privacy and security have occurred. My account is being administered by an unauthorized third party and Ms will not properly investigate. At present, the font and text size changes erratically as I am typing in Word, without any effort or intention on my part. Countless contacts with customer support and innumerable complaints filed have been ineffective. Cases are closed without review. The problem persists without any accountability. Any changes that I make to settings are then altered. Does anyone have an authentic, legitimate suggestion as to how I might — not merely correct this latest issue— but effectively reach a legitimate agency that will investigate these incursions at the data level?92Views0likes4CommentsNew Bug in Word Word (Version 2607 Build 16.0.20228.20124): QAT is not saved in template?
I often make template-specific customizations to the Quick Access Toolbar (QAT). As of today (August 04, 2026), these customizations are suddenly no longer being saved in a Word template. My tests revealed the following: For the customizations to be saved in a template, the UI-based process must create a “UserCustomization” subfolder in the template file (see the ZIP version of the file): The QAT customizations are saved in the “customUI.xml” file within this subfolder. In addition, the “.rels” file in the “_rels” subfolder receives a new entry: <Relationship Id="rId2" Type="http://schemas.microsoft.com/office/2006/relationships/ui/userCustomization" Target="userCustomization/customUI.xml"/> The UI-based process no longer creates the “User Customization” subfolder—an annoying bug! As a result, template-based QAT customizations are lost when a template is closed and reopened. Workaround: Make the described changes manually in the template file—this worked for me—but I hope Microsoft will fix this annoying bug! My Word Version: German UI, Version 2607 Build 16.0.20228.20124, 64 Bit. Can anyone confirm or disagree with this result? DieterG8Views1like0CommentsOffice Scripts - Working With Multiple Worksheets
I'm trying to write a script which writes data, via Power Automate, to multiple worksheets inside one workbook. I'm new to office scripts, so I'm not sure if I can do this in one script or if I have to do a separate script for each worksheet. Here is an example of the code: function main(workbook: ExcelScript.Workbook, Title: string, Type: string, Problem: string, Part: string, Date: string, Frequency: string, IDNumber: string, Comments: string, Originator: string) { let selectedSheet = workbook.getWorksheet("Issues"); //Populate All The Data selectedSheet.getRange("B6") .setValue(Title); selectedSheet.getRange("D6") .setValue(Type); selectedSheet.getRange("F6") .setValue(Problem); selectedSheet.getRange("B8") .setValue(Part); selectedSheet.getRange("D8") .setValue(Date); selectedSheet.getRange("H8") .setValue(Frequency); selectedSheet.getRange("K8") .setValue(IDNumber); selectedSheet.getRange("B9") .setValue(Comments); selectedSheet.getRange("F8") .setValue(Originator); } So that is the end of what I'm doing on the first worksheet, and it works perfectly, and now I want to do a similar thing on three more worksheets, in the same work book. Is there a way for me to add something to the code to start the process on the next worksheet? It won't let me use the "let" statement again to change the worksheet, which I thought might be how it worked, so I'm at a standstill now. Thank youSolved4.9KViews0likes4CommentsMicrosoft Defender for Office 365 Blocks Prompt Injections
Microsoft Defender for Office 365 (MDO) can detect and quarantine email containing prompt injections. Shared mailboxes might need MDO Plan 2 licenses if they receive email from external domains. This requirement existed before MDO introduced Prompt Injection Protection, but the advent of the new capability is another reason to check mailbox licensing, especially if your tenant uses Copilot. We have a script to help! https://office365itpros.com/2026/08/04/microsoft-defender-prompt-injection/13Views0likes0CommentsGetting error when adding Add-ins in Excel
Hi all, I have trying to install add-ins to microsoft excel using a M365 Personal Account, and i keep getting an error "Add-in Error: We couldn't connect to the '{0}' catalog server for this add-in" screenshot attached below. I have tried on both Excel Web and and on the desktop Excel app and still the same issue, I have already had a session with microsoft support and they were not able to resolve this for me and directed me to this forum, Any help will be appreciated thanks in advance.43Views0likes2CommentsStock symbol SKHY is missing in Excel's Stock data type
I have been frustrated trying to report a stock ticker symbol that is missing from Excel's Stock data type. SKHY is the ticker symbol for SK HYNIX INC ADR on NASDAQ. Excel responds with the following error when attempting to convert this symbol to a Stock data type: Data Type: Stocks No results found for "SKHY". How do I report this issue so that it can be fixed?140Views0likes4CommentsPlanning a Google Workspace to Microsoft 365 Migration? What Should You Consider?
Hi everyone, Has anyone recently migrated from Google Workspace to Microsoft 365? I’m interested in knowing what challenges you faced during the migration, especially around mailbox data, calendars, contacts, user mapping, or the final cutover process. For those planning the migration, what are the key things you recommend preparing before getting started? Would like to hear your experiences and suggestions.16Views0likes1CommentStrange redirect when signing in - phishing?
I just restarted my Business Standard 365 license today and this afternoon got an email from email address removed for privacy reasons with the following content: But when I clicked on the 'Verify payment information' button I am redirected to a page with the following URL: https://admin.cloud.microsoft/Error/UnAuth?errorCode=100014 looking like this: This looks highly suspicious (Times New Roman font, URL with no top-level extension such as .com, unusual graphics). Is this legitimate or a phishing attempt? Now, when I try to login to admin.microsoft.com to check my account the same suspicious "Sign out and login with a different account" page pops up repeatedly.133Views0likes6CommentsNesting a COUNTIF With IF To Evaluate A Formula
I have a sheet called Employee Training Matrix that I use to lookup data in a tab called Documents to see if there has been a date entered into a range of cells. Depending on how many dates are entered, the sheet will calculate the percentage where a person has been trained for a particular job. For example, the safety training requires three documents, so the formula I use for this lookup is "=COUNTA(Documents!C3:C5)/3". The issue is that some people do not require training in some areas, so I want to have the sheet to return a blank cell that I will format with a conditional format rule. Is there a way to do an IF and COUNTIF formula that will return a blank cell on one sheet when the second sheet has no date and run my COUNTA formula if there is? Or is there another way to address this? Thank you.Solved125Views0likes6CommentsHow to move user from a CSP Exchange Online licence to a Microsoft direct licence in the same tenant
I have an existing Microsoft 365 tenant with a single Exchange Online (Plan 1) licence that was purchased through Bluehost (Endurance International Holding B.V. CSP). Microsoft notified me that Endurance is no longer authorised as a Direct Bill CSP, so I decided to purchase a new Exchange Online (Plan 1) subscription directly from Microsoft My current situation is: Exchange Online (Plan 1) purchased through Bluehost/Endurance Exchange Online (Plan 1) purchased directly from Microsoft Both subscriptions are now active The problem is that Microsoft 365 appears to pool the licences together. Under Users → Active users → Licences and apps I only see Exchange Online (Plan 1) and there is no way to choose which subscription the user is assigned to. The licensing page simply shows: Licences assigned from all subscriptions: 1 / 2 The two subscriptions are only distinguishable by their billing profiles (one is the Bluehost/Endurance CSP subscription and the other is my new Microsoft direct subscription). I want to make sure my mailbox is consuming the Microsoft direct licence. How can I determine which subscription my user is currently licensed from? If the user is still consuming the CSP licence, what is the supported way to move them onto the Microsoft direct subscription? Is the licence automatically reassigned if the CSP subscription is cancelled, or is there a manual process that should be followed? I want to keep the existing tenant, mailbox, domain and email data and only change the billing source for the licence. Any guidance from anyone who has completed this transition would be greatly appreciated.4Views0likes0Comments
Events
Recent Blogs
- 8 MIN READBy Alex Pozin and Samer Baroudi Maintaining visibility and control becomes increasingly complex as organizations deploy more agents across multiple Microsoft 365 tenants, through a heterogenous...Aug 04, 2026238Views0likes0Comments
- Help employees find the right people faster with Assistant relationship dataJul 29, 2026435Views2likes0Comments