Forum Discussion
Solved
Slow Loading .xlsb File
Good morning everyone, I have a 2.5mb .xlsb file that takes approximately five minutes to load. It is only one sheet, but has some VBA in the background. It is a tracker, and I have entered in a l...
- You could use my free name manager addin https://jkp-ads.com/excel-name-manager.asp
Maybe a (hidden) range name with an external link? Those can slow down the opening considerably.
Where would I check for this? I suppose it is possible that I added something by mistake, but the code I pasted above is the only VBA used in the workbook. I checked connections and do not see any.
- ADGToreUp You can take my word for it. You should check for this as in my experience (broken) links hidden away in range names can cause precisely what you describe: a slowdown of loading your file.
- I ended up fixing it by copying everything over to another Excel file and then adding the code in. I believe you were correct though, somewhere hidden there was a link to another document.
- I understand security levels are important, but why prevent people from using the industry-standard add-ins? Our Name Manager has hundreds of thousands of downloads and has been in use for over two decades.
- I cannot use addins where i am because of the security levels. Otherwise I would try. I may send the file to my home computer and give it a try. I will let you know.
- You could use my free name manager addin https://jkp-ads.com/excel-name-manager.asp