Problem with chart

J

Jesper

I think I have pressed a button in my excelfile and i don't know what I have
done. I have an excel-file with alot of charts but I can't edit them. Nor can
i create new ones. Can anyone tell me where I can "unlock" the charts?

/Jesper
 
M

Michael

Have you Shared your workbook, if so, that will prevent you from editing the
charts
and creating a new one.

In order to correct this, you may have to "undo" the sharing. Downside is
that you loose track of all changes up to the moment you do this "unsharing"
 
A

Andy Pope

Hi,

Another possible cause maybe the selection of more than 1 sheet tab. If
this is the case the word [Group] should be displayed in the Excel
application title bar. Select a single sheet to remove grouping.

Cheers
Andy
 
Top