Avatar of XAnalyzer
XAnalyzer
Flag for United States of America asked on

Excel 2010 shared files crash PC

Strange situation but 5 users are sharing an Excel 2010 file (built in Excel sharing) that is located on a shared network drive but only One user's excel 2010 on PC (i7, 16gb RAM) is consistently locking up when this file stays open. I already tried repairing office 2010. I don't want to upgrade to 2013 just yet but any thoughts on why an (shared) excel file might be locking up excel on a fast computer?
Microsoft Excel

Avatar of undefined
Last Comment
XAnalyzer

8/22/2022 - Mon
XAnalyzer

ASKER
Found this url: http://answers.microsoft.com/en-us/office/forum/office_xp-excel/shared-workbook-freezing/2db672bf-7149-4952-838a-197bbdfadcf9?auth=1 seems to suggest that Sharing is not a stable feature. I find this hard to believe as the feature is necessary in businesses.
ASKER CERTIFIED SOLUTION
[ fanpages ]

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
[ fanpages ]

I don't want to upgrade to 2013 just yet but any thoughts on why an (shared) excel file might be locking up excel on a fast computer?

Have you checked the version (including all patches/updates applied) to the installation of MS-Excel 2010 on that PC compared with any/all of the others?

Any any Add-ins in use on that single PC that are not active on the others?
Is there any other differences in the installation of additional software?  I suspect there may be, so eliminated the potential source of the problem may be a long process.

However, does the "Shared" workbook operate 'normally' when just used by that one PC?
If not, does the situation improve if you stop sharing the workbook & return it to Exclusive-use?

Perhaps it is not the workbook at all, or perhaps it is just the content of the file that is causing a problem on that one machine or, even when a certain quantity of concurrent use is reached.
XAnalyzer

ASKER
Still locking up, I will try to go the Excel 2016 route and hope that fixes the sharing aspect.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck