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
Solved

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

Posted on 2011-02-10
8
273 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
Easy, flexible multimedia distribution & control

Coming soon!  Ideal for large-scale A/V applications, ATEN's VM3200 Modular Matrix Switch is an all-in-one solution that simplifies video wall integration. Easily customize display layouts to see what you want, how you want it in 4k.

 
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

Portable, direct connect server access

The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SKip past fields with no data 6 14
Excel formula to report date modified 14 24
Strategy Mapping Excel WB/WS 2 26
Index Match Formula VBA 6 19
If you're not part of the solution, you're part of the problem.   Tips on how to secure IoT devices, even the dumbest ones, so they can't be used as part of a DDoS botnet.  Use PRTG Network Monitor as one of the building blocks, to detect unusual…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
After creating this article (http://www.experts-exchange.com/articles/23699/Setup-Mikrotik-routers-with-OSPF.html), I decided to make a video (no audio) to show you how to configure the routers and run some trace routes and pings between the 7 sites…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

860 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