ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Problem with chart (https://www.excelbanter.com/excel-worksheet-functions/182064-problem-chart.html)

Jesper

Problem with chart
 
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

Michael

Problem with chart
 
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


Andy Pope

Problem with chart
 
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


All times are GMT +1. The time now is 11:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com