Excel 2002 SP1

[ash.arokiaswamy]

We use Excel 2002 SP1 to open workbook(s). The PC is a GX270, PIV 3GHz,
1GB RAM. There is a seperate hard drive for storing Excel files.

Each workbook is anywhere between 80MB and 140MB. We are able to open 1
130MB workbook without getting an error. If we open two workbooks of
about 130MB, Excel gives an error:

--
Excel cannot complete this task with available resources. Choose less
data or close other applications.
--


These workbooks do NOT have Pivot Tables or VLookups. They DO have
formula calculations within tabs (which are individual spreadsheets) in
the same workbook.

What is the best way to get atleast two workbooks open at the same time?

 

[Anne Troy]

There is something dreadfully wrong with 80 to 140 MB workbooks. Either you
need to clean them up, or you need to start using some other database
storage. Few PCs, regardless of size, will efficiently handle holding files
of this size in memory AND run calculations. Try cleaning them up:
http://www.officearticles.com/excel/clean_up_your_worksheet_in_microsoft_excel.htm
Also, try moving the sheets to new workbooks.
*******************
~Anne Troy

www.OfficeArticles.com

 

[Adam]

Do you not think that your asking a lot from your machine ?

Opening 80mb + spreadsheets which cause any machine to struggle.

What version of Windows are you using?

If Windows XP can you increase the process priority that is given to
Excel ?