Graphs and Drawn Objects Disappeared

[clemenke]

I have a large spreadsheet that I update weekly and have managers
validate OT hours. I had a bunch of drawn objects that I attached
macros to and also a graph on the top of the spreadsheet, All of a
sudden the graph has disappeared as well as all of the drawn objects.
Whats even stranger is that I no longer have the ability to draw
objects or create new graphs. The graphs can only be put on their on
page, the option to place as an object on a sheet is not there. I
also cannot paste any objects onto the pages. Anyone know what the
problem is??

 

[Naraine]

try copying what you currently have to a new workbook and then try to draw
the charts & objects.

naraine

 

[Debra Dalgleish]

From the Tools menu, choose Options.

I have a large spreadsheet that I update weekly and have managers
validate OT hours. I had a bunch of drawn objects that I attached
macros to and also a graph on the top of the spreadsheet, All of a
sudden the graph has disappeared as well as all of the drawn objects.
Whats even stranger is that I no longer have the ability to draw
objects or create new graphs. The graphs can only be put on their on
page, the option to place as an object on a sheet is not there. I
also cannot paste any objects onto the pages. Anyone know what the
problem is??