Forum Discussion

tatsenkoaa's avatar
tatsenkoaa
Copper Contributor
Sep 21, 2023

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?

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    I 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.

Resources