Forum Discussion
MikeA1335
Aug 25, 2022Copper Contributor
Excel for Mac insert Chart menu
I have an older excel file originally created in Windows. I am now using axel for Mac on a MacBook. The Insert Chart menu is greyed out. Problem appears to be with the file parameters as the insert chart menu is active with a new file. What should I do to make the insert chart menu active?
- No, the chart tools don't work on a new worksheet. I can copy a worksheet into a new file and the chart tools will work.
7 Replies
- The old workbook may have been saved in a binary file format that does not support Excel's current chart tools. To update the workbook, in Excel use File > Save As and change the format to Microsoft Excel Binary workbook (.xlsb). Then you should be able to use the chart tools.
- MikeA1335Copper ContributorThe file was originally saved in .xlsx format on a Windows version, I saved as .xlsb on my MacBook and I still couldn't access the chart tools.
- Check the Review tab of the Ribbon and click Protect Sheet and see if any restrictions have been turned on.