Problem opening 2 large spreadsheets

  • Thread starter Thread starter Pete Harris
  • Start date Start date
P

Pete Harris

If I am working on one speadsheet which is 24.5Mb and I try to open another
of the same size I get Microsft Excel dialog box advising "Not enough memory"
I am using Windows XP Home edition with 512 Mb RAM and an 80Gb hard drive
with 62Gb free space. On my previos windows 98 system I had no problem
opening these 2 files together.
Can anyone please help.
 
RAM is fairly cheap these days. Maybe a good time to upgrade to 1 Meg.
best wishes
 
You are probably right, but shouldn't I still be able to oppen these 2
spreadsheets with my current set up if I was able to do so with less memory
on Windows 98? Isn't there anything I can try?
--
Regards
Pete


Bernard Liengme said:
RAM is fairly cheap these days. Maybe a good time to upgrade to 1 Meg.
best wishes
Click to expand...
 
Probably due to xp using more of your precious memory.
Unless using expensive R type memory like a Dell I once had, memory is
cheap. Just make sure you add it properly for your computer. OR, get a new
computer while they are cheap.

Perhaps your files could be made more efficient to reduce size. Get rid of
unused.
Open one file>goto each sheet>use ctrl+end to see what you get.
Send the file(s) to my address below if you like.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Pete Harris said:
You are probably right, but shouldn't I still be able to oppen these 2
spreadsheets with my current set up if I was able to do so with less
memory
on Windows 98? Isn't there anything I can try?
Click to expand...
 
Thank you Charles. I never thought it was my system RAM that was the problem
but related to Excel memory. I have read through your link and think the
problem lies in the Last Cell of all sheets in the region of row 65530. I
have 12 sheets per spreadsheet with the highest required row number for any
sheet being row 50. I have tried to delete unwanted rows (using edit >delete
on highlighted rows) but when I press Ctrl/End I always go back to row 65530!
In other words the delete doen't seem to work. Also do you know a quick way
of selecting rows 50 to 65530 without waiting for the scrolling to take place?
--
Regards
Pete


Charles Williams said:
see http://www.decisionmodels.com/memlimitsc.htm and associated pages.
Click to expand...
 
Be sure you use DELETE for the rows/columns instead of clearcontents. SAVE
the file>try again.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
Pete Harris said:
Thank you Charles. I never thought it was my system RAM that was the
problem
but related to Excel memory. I have read through your link and think the
problem lies in the Last Cell of all sheets in the region of row 65530. I
have 12 sheets per spreadsheet with the highest required row number for
any
sheet being row 50. I have tried to delete unwanted rows (using edit
delete
Click to expand...
on highlighted rows) but when I press Ctrl/End I always go back to row
65530!
In other words the delete doen't seem to work. Also do you know a quick
way
of selecting rows 50 to 65530 without waiting for the scrolling to take
place?
Click to expand...
 
Select a complete row by clicking on the row number.
Then press Ctrl/Shift/Down arrow

As Don says try saving and reopening after you have deleted the rows.


regards
Charles
___________________________________
London Excel Users Conference April 1-2
The Excel Calculation Site
http://www.decisionmodels.com

Pete Harris said:
Thank you Charles. I never thought it was my system RAM that was the
problem
but related to Excel memory. I have read through your link and think the
problem lies in the Last Cell of all sheets in the region of row 65530. I
have 12 sheets per spreadsheet with the highest required row number for
any
sheet being row 50. I have tried to delete unwanted rows (using edit
delete
Click to expand...
on highlighted rows) but when I press Ctrl/End I always go back to row
65530!
In other words the delete doen't seem to work. Also do you know a quick
way
of selecting rows 50 to 65530 without waiting for the scrolling to take
place?
Click to expand...
 
Sounds like the spreadsheet was upgraded from lotus notes or a much
earlier version of excel.

You need to manually or with a little bit of vba code wipe out all the
empty rows.

If the spreadsheet is still quite a few M then maybe you have too much
data.
If then the majority of the sheets is the same data filtered a little
differently, then a vba appication to create extra workbooks with this
data is a much better option.

Tom Bizannes
Excel Development
Sydney, Australia
http://www.macroview.com.au
 
Back
Top