Solved

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

Posted on 2011-02-10
8
275 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
Industry Leaders: 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!

 
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

Industry Leaders: 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

Suggested Solutions

Title # Comments Views Activity
Excel + CountIfs + two colums 5 40
Cell Manipulation 37 53
Search functions & INDEX Match 11 22
Disable auto refresh in a sheet 2 15
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

739 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