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 ...
JKPieterse
Sep 21, 2023Silver 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.
Happy to analyze your file off-line if you're interested.