Forum Discussion
Suddenly don't have access to charts (grayed out)
paulabbottThat sounds like it's a protected sheet then. You'll need the password. The original author of the file will hopefully have it. Find the file and right click it, then go Properties > Details ... Authors will be one of the fields in there. You can also hopefully see who last saved the file... Hopefully you can track down who in your organisation to email and get a password. Good luck!
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 👍