excel
347 TopicsMicrosoft Sign In Loop
I am trying to sing into Microsoft 365, but every time I do, it takes me back to the login screen. I sing in with my outlook account, but I can't reach the applications. I can sign in on the browser, but not the applications on my computer. I have tried uninstalling and reinstalling M365, but the issue still persists108Views0likes1CommentAutoSave disabled when opening SharePoint-synced files from Finder after macOS Tahoe 26.6 update
Files stored in SharePoint Online and synchronized locally through OneDrive are opened as local documents when launched from Finder. Office applications display "Saved to my Mac" and AutoSave is turned off by default. However, opening the exact same files through Word/Excel > Open > Sites, or via SharePoint "Open in Desktop App", correctly identifies them as cloud documents. In that scenario, AutoSave is enabled and collaboration/version history features work as expected. Troubleshooting already performed: OneDrive reset and re-linked SharePoint library re-synced Signed out and back into both Office and OneDrive Removed Microsoft credentials from macOS Keychain and re-authenticated Recreated local OneDrive sync relationships Verified OneDrive File Provider extensions are enabled Verified Office applications and OneDrive are fully up to date Tested with newly created files and existing files Tested "Always Keep on This Device" with no change in behavior The issue appears to be specific to the Finder-to-Office launch path after upgrading to macOS Tahoe 26.6. Before upgrading to macOS Tahoe 26.6, opening the same SharePoint-synchronized files directly from Finder correctly preserved cloud document identity and AutoSave was enabled as expected. I discussed this issue in detail with Apple Support, but they quickly dismissed it, saying that the problem is not on Apple's side and that I should contact Microsoft instead.4.2KViews13likes39CommentsOneDrive files opened from Finder not recognized as cloud files on Mac
Office for Mac: OneDrive files opened from Finder no longer recognized as cloud files – AutoSave disabled Hi everyone, I am experiencing a persistent issue with Microsoft 365 for Mac and OneDrive that started suddenly around August 10, 2026. The same setup and workflow had worked without problems for more than two years before that. Problem My Office files are stored in OneDrive and synchronized to my Mac via the standard macOS File Provider. When I open an Excel or Word file by double-clicking it in Finder, the Office application opens the file, but it apparently does not recognize it correctly as a OneDrive/cloud file. For example: AutoSave is disabled real-time co-authoring does not work as expected when I try to enable AutoSave manually, Office behaves as if the file were local and asks me to upload/save it to OneDrive – even though the file is already stored and synchronized in OneDrive However, if I open the exact same file from within Excel or Word via the OneDrive/Online Locations option, everything works correctly: AutoSave is enabled immediately co-authoring works changes made by another user appear in real time This behavior is reproducible with multiple files and affects both Excel and Word, so it does not appear to be an issue with one particular workbook or application. Environment MacBook Air M2 current macOS version current Microsoft 365 version current OneDrive version OneDrive Personal files synchronized through the standard macOS File Provider I have also tested opening files directly from: ~/Library/CloudStorage/OneDrive/... The result is the same: when opened from Finder, Office does not appear to recognize the file correctly as a cloud file and AutoSave remains disabled. Troubleshooting already performed I have already: completely reset and reconfigured OneDrive allowed OneDrive to fully resynchronize verified the files and folders in OneDrive on the web confirmed that OneDrive reports everything as synchronized restarted Finder and macOS removed and recreated Finder shortcuts/favorites tested without Finder favorites or aliases tested directly from ~/Library/CloudStorage/OneDrive updated macOS updated all Microsoft 365 applications updated OneDrive None of these steps changed the behavior. Key diagnostic result The following comparison is consistently reproducible: Finder → OneDrive file → double-click → Excel/Word → AutoSave OFF → file appears not to be recognized as an active OneDrive cloud document → co-authoring does not work correctly Excel/Word → Open → OneDrive/Online Locations → same file → AutoSave ON immediately → cloud functionality works → co-authoring works correctly This suggests that OneDrive synchronization itself is functioning correctly. The issue seems specifically related to the handoff between macOS Finder / Apple File Provider / OneDrive and Microsoft 365 for Mac when a OneDrive file is opened from Finder. Important detail This is not a workflow that has never worked on macOS. For more than two years, we routinely opened our synchronized OneDrive Word and Excel files directly from Finder. Office recognized them as cloud files, AutoSave was available, and collaborative editing worked normally. The behavior changed suddenly around August 10, 2026, without us intentionally changing the OneDrive folder structure or our workflow. Question Has anyone else encountered this recently? In particular: Is this a known regression in Microsoft 365 for Mac, OneDrive for Mac, or their integration with Apple's File Provider? Why would Office recognize a file as a OneDrive cloud document when opened through the application's Online Locations, but not when the exact same synchronized file is opened from Finder? Is there a way to reset or repair the Microsoft 365/OneDrive cloud-file recognition or File Provider integration without resetting the entire OneDrive again? Are there any relevant logs, caches or diagnostics that could show why Office considers a Finder-opened OneDrive file to be local? Opening every document through the Office application's Online Locations is a possible workaround, but it is not a practical long-term solution when working with a larger shared folder structure in Finder. I have already contacted both Apple Support and Microsoft Support. Apple referred me to Microsoft, and Microsoft Support subsequently recommended that I raise the issue here in the Tech Community. Any insight from Microsoft staff, MVPs or others familiar with Microsoft 365 for Mac, OneDrive and the macOS File Provider would be greatly appreciated.1.4KViews7likes9CommentsWhat's wrong with my XLOOKUP formula?
I'm trying for the first time to define cells in an Excel worksheet with values selected from list, which is defined by a table. The table is in the same worksheet, to the right of my data columns. I was OK until I tried to make the cell look up the value in one table column (an ID) and display the corresponding value from another column. I'm defining the cell with data validation, type list, using this expression for source: =XLOOKUP(D2,CatTable[ID],CatTable[Categories]) Where D2 is a data cell, CatTable is the table's name, and ID and Categories are respectively the names of the ID and display columns. When I click OK, Excel says "There's a problem with this formula" (followed by some useless stuff that assumes I don't know what a formula is and entered one by mistake). What is wrong?107Views0likes3CommentsCopy/cut/paste works normally until a row contains an image
Hi I need help, I have used excel for decades, and never had an issue with images (besides occasionally taking a little while to copy, cut and paste a row). However, since last week, I can't select a row, copy, cut and paste, if in the row is an image. Excel version (16.113.3) MacOS version (Tahoe 26.2) This is occuring whether in a brand-new workbook or an old workbook. I have deleted excel for applications, and reloaded, 3 times, I have shut down and restarted multiply times, I have had 3 people from Excel try to trouble shoot, 2 of them used 'Quick Assist' with no luck to sort the issue. I have to be able to work with images, or else my excel is not suitable after being able to use excel for decades. I'd love assistance. Regards Vanessa87Views0likes1CommentHelp Desk Sent Me Here...Help!
I'm getting the msg in a ribbon at the top of my excel files as follows: COULDN'T VERIFY SUBSCRIPTION Excel couldn't verify your Microsoft 365 subscription. Please make sure that you're connected to the Internet. ( I am ). we've rebooted several times, uninstalled, reinstalled etc. I can open all my excel files, but can't edit or save them. All dropdowns are "grayed" out. Microsoft Help Desk sent me here.169Views0likes2CommentsMac OS 26.7 and M365 Office Applications- upload block errors only on Office applications.
Mac OS 26.7 and M365 Office Applications- upload block errors only on Office applications. When making changes to an Office document like Excel &/or Word using M365 E5 license since September 19th, I have been getting a message stating "Upload blocked" in autosave, the file is being saved to a OneDrive connected services which has a capacity of 5 tb, having a total of about 860,000 items, about 3.2 TB, but the selected items to sync from the OneDrive application is about 180,000. This happens sporadically to only Office application files such as MS Word and Excel. The syncs in the bar menu of OneDrive all show sync and backed up with no errors. As per MS a M365 SharePoint library can hold 30 million items, and view is limited to 5000 items, and I have such libraries with about 20,000 items and I can access them online and have set views to show items in lists less than 5000. MS also states that OneDrive Business can sync up to 300,000 items only even if the capacity is 5 TB and the number of total items cannot exceed 300,000 items. (1) Does anyone know why a OneDrive storage which leases 5tb storage space can only keep 300,000 items, for it to function? (It’s pointless to lease 5tb and be restricted by number of items). (2) Sync is working for PDFs and screenshots but only Office applications are having problems syncing at times or saving with autosave with versions. When I researched with CoPilot Premium running several terminal commands it concluded it is a MS Office bug and MS Support cannot solve the problem despite opening several tickets. The agents as L1 will scope, then it goes to the backend team called “ Escalations” but there remains no solution for crippled services since past 11 days. OneDrive sync logs were provided as well as requested but no followup. (3) If these are hard limitations on M365 to save maximum of only 300,000 items has anyone considered any other cloud services to replace OneDrive for Business? Has anyone else experienced this in the past? Can anyone offer a solution for this? If OneDrive office applications are dysfunctional then how does one operate AI agents or any automation. Any questions please ask. Thank you.220Views0likes4CommentsNot able to refresh stock data
An error message:" You need to be online to refresh your linked data types. Check your connection and try again" When I refreshed stock data today and not able to get the updated data. They just fixed a week long issue yesterday, another issue happens today, please help to fix it asap.143Views1like2CommentsClaude Add-in Error in Excel
Hi Microsoft Community, I'm having an issue with the Claude for Microsoft 365 add-in in Excel for Mac. Environment: Mac Microsoft Excel desktop for Mac Personal Microsoft account (not a work or school account) Claude for Microsoft 365 add-in Excel for the web Issue: When I try to add or use Claude in the Excel desktop app for Mac, I receive this error: “Add-in Error: You don't have permission to use this add-in. Contact your system administrator to request access.” The important point is that I am using a personal Microsoft account, so there is no organizational administrator managing the account. What I've confirmed: The Claude add-in works successfully in Excel for the web using the same Microsoft account. The problem occurs specifically in the Excel desktop application on Mac. This appears to point to an issue with the Mac Office client, add-in authorization, or the Office add-in catalog rather than my Claude account or Microsoft account permissions. I've already tried closing and reopening Excel, but the permission error remains. Has anyone encountered this with Claude for Microsoft 365, or with other Office add-ins, on Excel for Mac? In particular, is there a known issue with personal Microsoft accounts and Office add-ins on the Mac desktop client? Is there a way to reset the add-in/account authorization without reinstalling Office? Thanks.103Views0likes0CommentsError loading add-ins. One or more add-ins failed to load. See your add-ins.
No matter which Office applications I use (Excel, Word, PowerPoint, etc.), if a try to install an add-in. I get the above error message. This happens with any add-in. Does anybody have a solution for this? Thank you.364Views1like2Comments