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!
 

Some videos you may like

Excel Facts

How to fill five years of quarters?
Type 1Q-2023 in a cell. Grab the fill handle and drag down or right. After 4Q-2023, Excel will jump to 1Q-2024. Dash can be any character.

sijpie

Well-known Member
Joined
Nov 1, 2008
Messages
3,661
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,099,038
Messages
5,466,164
Members
406,471
Latest member
tsou88

This Week's Hot Topics

Top