Prevent Excel From Loading Charts When Opening File

[Prevost]

Hi There. Is there a way to prevent excel from loading and displaying charts on worksheets and tabs when the file is opened? We have charts that plot many data points and opening the file can be lengthy when you wait for the chart to load. Also, when you scroll through a sheet it pauses at the chart to load it. Is there a way to choose not to load charts, but with the option of doing so later?

Thanks!

 

[sijpie]

I would suggest that in the workbook_open macro you hide any chart tabs (simple loop) and set the chart ranges for the embedded charts to an empty range and display a message in the chart that a certain button needs to be pressed to show the charts.

then code this button to show the chart tabs and set the embedded chart ranges to what they need to be. bit of work to set it up, but then it should be easy to use. the sheet