Solved

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

Posted on 2011-02-10
8
276 Views
Last Modified: 2012-08-13
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.
0
Comment
Question by:transam25
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 

Author Comment

by:transam25
ID: 34864117
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....
0
 
LVL 45

Expert Comment

by:patrickab
ID: 34871788
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
0
 

Author Comment

by:transam25
ID: 34871819
Yes.
0
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
LVL 45

Accepted Solution

by:
patrickab earned 250 total points
ID: 34871844
transam25,

You won't like my response but this is a common problem. My notes on this issue are:

Shared Excel files:

Excel does not handle 'Shared' workbooks reliably. They are often corrupted at random and apparently without cause. Clearly there is a cause but it has not yet been isolated and fixed by MS. There is nothing you can do to avoid shared workbooks corrupting. The ONLY thing that can be done is to make them single user.

To help you with the single user file system try adopting this approach instead. It does work rather well so it's worth doing. First make the file(s) single user. Second edit everyone's user profile in Excel - Tools/Options/General/UserName and in there put the person's name and telephone extension number. Then whenever you attempt to open a file that someone else is using, a dialogue box will pop-up telling you who is the current user - and it tells you their telephone extension number! The new user can opt to either call the current user or open the file as read-only.

I realise it seems odd that MS would have an unreliable feature in Excel but I'm afraid that's the way it is. If you must have simultaneous access then it would be wise to use a proper database.

For Office 2007:  Office Button > Excel Options >Popular tab >User name

Hope that helps

Patrick
0
 

Author Comment

by:transam25
ID: 34871902
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.
0
 
LVL 45

Expert Comment

by:patrickab
ID: 34871947
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
0
 

Author Comment

by:transam25
ID: 34872168
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................
0
 
LVL 45

Expert Comment

by:patrickab
ID: 34872616
transam25 - Thanks for the grade - Patrick
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

627 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question