Excel very slow!! please help

[may13]

Hello,


I've created a dashboard in excel 2007 with a lot of conditional formatting to show Gantt Chart. When I add camera tool objects (to show dates on my bars) it become very slow.


Is there any solution to my problem?

Thanks a lot

 

[Hui]

May13


Firstly, Welcome to the Chandoo.org Forums


Have you tried using linked Cells in a Text Box instead of the Camera tool?


Otherwise have a read of these posts and web sites


http://chandoo.org/forums/topic/slow-excel

http://msdn.microsoft.com/en-us/library/ff700515.aspx

http://www.decisionmodels.com/calcsecrets.htm

http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm

 

[may13]

Thank you very much Hui. in fact I still need to use camera tool for the dashboard other than dates displayed on the bars.