Solved

Maximum Excel file size?

Posted on 2007-03-29
4
3,424 Views
Last Modified: 2009-01-21
All of our users are on Excel 2003 on Windows XP SP2 machines.
One of them has a 100Mb file that he uses to perform calculations on using complex formulae. Info from this is then picked up by other Excel files.

Recently, his computer has been throwing up errors stating that it doesn't have the system resources to either keep the file open, or make a change to it - the exact message is: "Excel cannot complete this task with the available resources. Choose less data or close other applications". He generally then opens a new Excel file. When he sends the mail out, he also notices corruption and external users are unable to open it.

Does anyone know what the maximum recommended Excel size is?

Also, could the sequence of events I've described result in corruption of the file?

Urgent, so max points!

Cheers

0
Comment
Question by:kam_uk
[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
  • 2
4 Comments
 
LVL 81

Expert Comment

by:zorvek (Kevin Jones)
ID: 18817334
I have worked with workbooks around 70 to 80 Mb but not bigger than that. Everything I have read indicates that a workbook can be any size but there are specific limitations for specific objects within the workbook. My guess is the user is just pushing the limits of the workstation as configured and needs an upgrade.

Kevin
0
 
LVL 81

Assisted Solution

by:byundt
byundt earned 200 total points
ID: 18817799
You may find the discussion here of interest http://msdn2.microsoft.com/en-us/library/aa730921.aspx
Among other things, different versions of Excel can take advantage of different amounts of RAM. So upgrading the version of Excel may be a partial solution to your user's problem.
0
 
LVL 3

Author Comment

by:kam_uk
ID: 18820072
Thanks for the link.

zorvek - "My guess is the user is just pushing the limits of the workstation as configured and needs an upgrade."

if the excel workbook was not closing down properly, or terminating in the middle of an action, could this lead to corruption?

thx
0
 
LVL 81

Accepted Solution

by:
zorvek (Kevin Jones) earned 300 total points
ID: 18820311
>if the excel workbook was not closing down properly, or terminating in the middle of an action, could this lead to corruption?
Yes, and unfortunately, the larger the workbook gets, the greater the chance for corruption to creep in. A workbook is a very complex structure and as soon as parts of that structure start getting buggered weird things start happening. One tool I have been using to repair workbooks with great success is Workbook Rebuilder from www.vbusers.com.

Kevin
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

My attempt to use PowerShell and other great resources found online to simplify the deployment of Office 365 ProPlus client components to any workstation that needs it, regardless of existing Office components that may be needing attention.
This article describes a serious pitfall that can happen when deleting shapes using VBA.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seveā€¦

626 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