Forum Discussion
Excel 2016 slow to load many charts in workbook
Greetings
An issue that has come up in Excel 2016 ... Excel 2016 seems to load charts on demand. Here is my scenario ...
An Excel file has 50+ complex charts on Sheet 2. The Excel file opens with Sheet 1 active when the file is opened. When you click Sheet 2, the Charts "generate" sequentially. Slowly.
In Excel 2013, the charts would be "preloaded" when the file was opened, and clicking on Sheet 2 would show the charts immediately.
The issue is that when Sheet 2 is opened in Excel 2016, the many complex charts take 4-5 seconds to display.
I work around the issue by activating the sheets using ....
Private Sub Workbook_Open()
'loop all sheets by index
For i = 1 To ThisWorkbook.Sheets.Count
Sheets(i).Activate 'test both activate and select to see if chart loads faster
Next
Sheets(1).Activate
End Sub
QUESTION: How can I properly "preload" charts in all worksheets in Excel 2016?
A simple excel file is attached to demonstrate the issue. It is happening on Excel 2016 version 1710 and 1609 (the only 2 versions I have access to). I make the file open to Sheet 1 by being on Sheet 1 and then saving the file and closing it. A simple file, and a macro file are attached. I could not attach 2 files, so a zip is attached