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

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"
--
If this posting was helpful, please click on the Yes button.
Regards,

Michael Arch.




"Jesper" wrote:

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

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

Jesper wrote:
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

--

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