We have a file in our company, and it takes 25mins to save. The file is 24mb before, but now it is 5mb because I saved it in "xlsb". I've searched answers and tried disabling auto calculation and some other stuff but still can't save it faster.
The file contains 13,000+ cells of hyperlinks to our network. I think the hyperlinks are the problem.
The file is locally stored in my hard drive, I'm the one who is updating it. It only contains hyperlinks and some formulas to count how many open and close issues are there.
hyperlinks looks like this....
\\companyname.com\server112\E&PM\PM\Project Filing\Transmittals\Incoming\D1-T-P-8241
I think hyperlinks are the problem, because I''ve tried removing hyperlinks from i.e Row 5-4000, and the saving time is being reduced. Hope you can help me
Thanks, I appreciate your reply.
Bookmarks