Link to home
Start Free TrialLog in
Avatar of transam25
transam25

asked on

Resource error message on Excel shared network files after 2007 upgrade from 2003.

Our office upgraded from Office 2003 to 2007. Now on shared Network Excel files we frequently receive the error Message: Microsoft Excel does not have enough resources to complete this operation. We did not receive this error prior to the upgrade.
Avatar of transam25
transam25

ASKER

The exact message is Excel cannot complete this task with available resources. Choose less data or close other applications. Continue with undo? Then it says Microsoft Excel has stopped working. Windows is checking for a solution to the problem. Then it finally saves or opens....
transam25,

Are the Excel files being used in 'shared' mode? In other words can more than one person use the same file at the same time?

Patrick
Yes.
ASKER CERTIFIED SOLUTION
Avatar of patrickab
patrickab
Flag of United Kingdom of Great Britain and Northern Ireland image

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
Thanks Patrick!

Curious though, why this did not start occuring until we upgraded from 2003 to 2007? These are 2007 files are on the same Shared Network and they were Shared excel files in 2003 but we did not have this issue.
transam25,

File corruption of shared files is totally random in all versions of Excel. I think you were just lucky with Excel 2003. This issue comes up just about every week here on EE - that's why I have my notes prepared!

Patrick
I thought these were Shared where more than one user could open and make changes but I just verified that the last two Excel files that this occured on are on the Shared folder but they can open view in Read Only mode, when another user is editing thet file................
transam25 - Thanks for the grade - Patrick