Link to home
Start Free TrialLog in
Avatar of XAnalyzer
XAnalyzerFlag 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?
Avatar of XAnalyzer
XAnalyzer
Flag of United States of America image

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
Avatar of [ fanpages ]
[ fanpages ]

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of [ fanpages ]
[ 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.
Still locking up, I will try to go the Excel 2016 route and hope that fixes the sharing aspect.