After using the same spreadsheets for months, my charts have "greyed out".
When I click on one, it becomes visible, but all the others remain blank,
i.e. grey. If I try to print the sheet, only the one I have clicked on
prints, the others print out grey. Could this be a memory issue?

Hi,

Try Tools Options and on the View tab set the Objects to Show All.

Cheers
Andy

phandi wrote:
After using the same spreadsheets for months, my charts have "greyed out".
When I click on one, it becomes visible, but all the others remain blank,
i.e. grey. If I try to print the sheet, only the one I have clicked on
prints, the others print out grey. Could this be a memory issue?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Thanks so much, Andy. Worked like a charm! Don't know why the Show All button
was not checked, but at any rate, now I know how to fix the problem. And such
a speedy response! Thank you.
Happy Monday!
Diane (phandi)

"Andy Pope" wrote:

Hi,

Try Tools Options and on the View tab set the Objects to Show All.

Cheers
Andy

phandi wrote:
After using the same spreadsheets for months, my charts have "greyed out".
When I click on one, it becomes visible, but all the others remain blank,
i.e. grey. If I try to print the sheet, only the one I have clicked on
prints, the others print out grey. Could this be a memory issue?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info