Forum Discussion
Suddenly don't have access to charts (grayed out)
I have owned MS Office (not 365) for a few years and I had been charting my financial data that I enter into an Excel spreadsheet each week. Now, suddenly, when I try to chart my data, the recommend...
RichardWeeks Thank you for this comment and suggestion! When I realized it was protected, I decided to copy the portions i needed to a new excel document. That must have not carried with it the protection because I was able to modify as needed. Thank you for starting me on this solution with your comment!
paulabbottGreat! I was going to suggest copying out the bits you needed. It works for smaller files, but larger worksheets can have so many linked fields from other tabs that it ends up with tons of cells filled with '###'. Glad to have been of assistance 👍