Prevent Excel From Loading Charts When Opening File

Prevost

Board Regular
Joined
Jan 23, 2014
Messages
198
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!
 

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,734
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
 

Watch MrExcel Video

Forum statistics

Threads
1,129,791
Messages
5,638,329
Members
417,021
Latest member
moon miner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top