Turned Charts Off
Turned Charts Off
(OP)
Hello Everyone,
I have accidentally done something I've never done before in Excel. I've turned off all my charts in a workbook. I still have all my data, but I cannot insert a chart. The icons on the ribbon for charts and illustrations are not active.
Does anyone know how I did this?
I have accidentally done something I've never done before in Excel. I've turned off all my charts in a workbook. I still have all my data, but I cannot insert a chart. The icons on the ribbon for charts and illustrations are not active.
Does anyone know how I did this?
RE: Turned Charts Off
Don't you have any backup copies, previous versions, save as versions, etc?
RE: Turned Charts Off
I will check the sheet protection when I get back on my comouter. ThAnks for the suggestion.
RE: Turned Charts Off
Office Button > Excel Options > Advanced > Display > Display options for this workbook: For objects, show: All
or because you have selected multiple sheets (you will see [Group] in the title bar) [Right-click a sheet tab > Ungroup sheets]
or because you have shared the workbook (you will see [Shared] in the title bar) [Review > Changes > Share Workbook> Editing: uncheck the checkbox]
RE: Turned Charts Off
It was the first suggestion you posted... much appreciated.