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

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

It is possible you have more than one worksheet selected.

Do you see [group] behind the filename in the titlebar?

If so, you have grouped two or more sheets.

Right-click and "ungroup".

Note: while sheets are grouped, what is done to one will be done to all, so
carefully check to see what changes have been made.


Gord Dibben MS Excel MVP

On Thu, 5 Apr 2007 16:12:00 -0700, 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