Forum Discussion
tatsenkoaa
Sep 21, 2023Copper Contributor
Long opening excel files in office 2019 volume
Good afternoon.
Faced with such a problem, we have large excel files in our organization, which collect the indicators of many stores, use a large number of macro links and formulas. When trying to open it in enterprise excel 2019 volume version 1808 (assembly 10402.20023), the file opening time exceeds 45 minutes. And excel 2019 Retail Version 2308 (build 16731.20234) and excel 365 the same version open it in 1 minute. Unfortunately, we cannot use versions other than excel 2019 volume. How can I optimize a file or excel settings to speed up the opening time of a file? And the second question is why is there such a difference in loading time at all, because 1808 (build 10402.20023) is a new build with updates?
- JKPieterseSilver ContributorI suggest to check your file for broken links. Open the Data, Edit links dialog and check all the ones listed. In addition, check it there are any links hidden in (hidden) range names. To ease that process, download and open my free Name Manager add-in from https://jkp-ads.com/excel-name-manager.asp
Happy to analyze your file off-line if you're interested.