I've been trying to update an Excel chart but all of my chart options were greyed out. Turns out if your workbook is shared so multiple people can make edits to the spreadsheet(s) at the same time, you cannot edit your charts. Go to Tools -> Share Workbook-> and uncheck the box to Allow changes by more than one user...
The system will kick everyone one else out of the spreadsheet and you can then make your changes to the graph. Once completed go back into Share Workbook and re-share.
Subscribe to:
Post Comments (Atom)
Posts
No comments:
Post a Comment