Dreye
asked on
Excel files freezing when linking other excel files
Hello,
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Regmigrant
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.
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.
ASKER
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
- 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
ASKER
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.
David