Excel files freezing when linking other excel files


We have a user who is working on an excel file (MS Office 2010-32bit) which has links to another file. The issue we are having is when we try to link a file or even do anything with the spreadsheet, it freezes for about 3 to 5 minutes before the action is performed. The two files we are working on are not huge files, one is 4 Mb while the other is about 500 kb. The files are on a network share drive. But to take the network portion out of the equation I moved the files to the local PC. The files linked together on the PC still behaved the same way, they froze anytime a link was added. Any advice would be helpful.

We are using a Windows 7 PC 64bit
File server is windows 2012
DreyeIT AdministratorAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Here's some things to help narrow it down:
- Try doing a 'file, save as' and switching to another format (xlsx to xlsb for example). Excel collects a lot of fluff over time and this clears some of it out
- turn off auto calculation whilst making the link and see if the delay moves to when the calculation is manually started

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DreyeIT AdministratorAuthor Commented:
Hello regmigrant,

I certainly have not tried that. I will give it a try and post the results as soon as I do. Thank you for your feedback.

DreyeIT AdministratorAuthor Commented:
We have switched over to the xlsb format and the files do work faster. The only drawback is that some of the formulas do not work after the file has been saved so we are simply saving the file back as a xlsx. This seems like a good method to get by but definitely not a long term solution.
DreyeIT AdministratorAuthor Commented:
Thanks remigrant for your assistance. Your tips provided us with a short term solution and that is basically what we needed. Something so that we could meet our deadline.
Hi Dreye, its interesting that some formulas fail after saving as an xlsb, they should all work unless you are using something that's been deprecated. Would you post an example of the ones which stopped working?

- unless it was a link based on a filename!

The clutter is cleared by the save as so once you  do it again - and re-create the xlsx - it should be ok. In most cases the extras are the result of many changes/saves over time so occur mostly during development and less so in practice but for a medium/long term solution its worth reviewing the end to end process and taking a look at the structure as well as the formula and any macros
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.