Solved

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

Posted on 2011-02-10
8
272 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
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 
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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Short answer to this question: there is no effective WiFi manager in iOS devices as seen in Windows WiFi or Macbook OSx WiFi management, but this article will try and provide some amicable solutions to better suite your needs.
PRTG Network Monitor lets you monitor your bandwidth usage, so you know who is using up your bandwidth, and what they're using it for.
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…

773 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