Delete a sheet and access charts
Try opening the file with the 'Open and Repair' Option found by clicking the
arrow next to the Open Button on the Open Dialog Box.
E.g. Click: File /Open then Highlight the File then click on the arrow to
the right of the 'Open' Button on the Open Dialog Box then select 'Open and
Repair.
If the file can be repaired you will need to use the 'Save As' Command
because the repaired file doesn't take the place of the original file that is
being Opened and Repaired.
--
Thanks please help!
"Jim--Kent" wrote:
I have a workbook with several pages of data. I have a sheet named Reports
that has several charts that display the data from other sheets. This week
the entire page of charts cannot be editted, the drawing toolbar icons are
dithered out and cannot be used, the protection menues are dithered out and
the sheet or workbook has not been protected, and the sheet itself cannot be
deleted as that menu is also dithered out.
I'm stumped as to what happened
|