Hi,

Do you have multiple sheets selected?
If the workbook/sheet protected?
Is it a shared workbook?

Is it only 1 file that displays the symptoms you describe?

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"clark" wrote in message
...
My charts, graphs, and conditional formatting tabs are all faded out and
inaccessable, as if they are deactivated. What can I do to use them?