Excel for Macbook Pro… Charts stopped being allowed all of a sudden???

I have the Micro 365 ver 16.99.2 for years… all of a sudden, while updating a spreadsheet with a graph, I loaded it and the graph was gone and I tried to redo it but all grayed out for inserting a chart.. I tried to find the options menu and the sheet is NOT protected.. so I am at a loss.. and its only this one workbook.. others are all working ok… any assistance will be greatly appreciated.

thanks in advance.

Skip




MacBook Air 13″, macOS 15.5

Posted on Aug 2, 2025 11:33 AM

Reply
5 replies

Aug 3, 2025 11:03 PM in response to William Huisking1

Microsoft 365 relies on cloud-based services, with OneDrive being the primary platform for file storage and synchronization. If you’re experiencing issues with certain features in Microsoft Excel on your Mac, it’s important to consider the following possibilities:


  1. OneDrive Subscription Status: Ensure that your OneDrive account is active and properly signed in. If your subscription has expired or there’s a sync issue, Excel may not be able to fetch or save data properly.
  2. File Synchronization Issues: The Excel file you’re working on may not be fully synced from OneDrive, especially if you’re using multiple devices or have a weak internet connection. This can lead to missing data, partial functionality, or outdated content being displayed.
  3. Accessing the Wrong File: You may be viewing or editing a local copy of the file instead of the most recent version stored on the cloud. Double-check that you’re opening the correct file directly from your OneDrive directory in Finder or through the Excel app.
  4. Compatibility Limitations on macOS: While Excel for Mac is quite powerful, some features available in the Windows version—such as certain VBA macros, data model tools, or add-ins—may not be fully supported. This is a software limitation, not a hardware or macOS issue.
  5. Developer or App-Specific Bugs: If the issue persists after verifying OneDrive access and file integrity, it’s best to consult Microsoft Excel Support. They can help troubleshoot app-specific problems, especially if it’s a bug or a known issue with the Mac version.


In short, these kinds of problems are typically not caused by macOS itself but rather by how the Excel app interacts with OneDrive or the particular file you’re accessing.

Aug 4, 2025 01:13 PM in response to SravanKrA

I really appreciate your advice… I worked on the ONedrive but it didn’t work.. plus , the charts did work up until recently on this workbook… When I load it, it give the message “read only” and I chose NO…. it only started doing that recently.. .something weird happened… been using this workbook for years and only now have the issue. Other workbooks allow chart.. its really frustrating because I really use the chart function with trends and regression analayis’… any help would be greatly appreciated… thanks Skip

Aug 5, 2025 11:55 AM in response to William Huisking1

We can help with Apple products but as SravanKrA already wrote Excel is a Microsoft product. I suggest that you post your question in a Microsoft product support site such as https://learn.microsoft.com/en-us/answers/, or contact Microsoft directly, here: https://support.microsoft.com/en-us


For example, Numbers is an Apple product, and there is a dedicated Community for it with many experienced users eager to help: Numbers - Apple Community

Aug 6, 2025 06:10 AM in response to William Huisking1

Ok, finally figured it out… its not the ONE drive issue. Its a quirk… somehow with an update, my file was changed to a read only but even though when I loaded it I clicked NO to allowing it as a read only… it shut off charts etc. To fix it, I had to load it, click “save as” and then “options” and then NOT read only… when doing this, the charts are now allowed. Go figure.. Thanks for all the suggestions… much appreciated…


Excel for Macbook Pro… Charts stopped being allowed all of a sudden???

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.