Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel size limit problem

Status
Not open for further replies.
frankiem

frankiem

Technical User
Jan 21, 2003
11
I am using Excel 2000. I have raw data in 60,000 rows and 7 columns in one sheet. In another sheet, I am trying to copy down some formulas that relate to the first sheet. I can copy down as far as row 47,000. When I try to copy below this, even is small chunks, I get a message saying that my system resources cannot display the output and Excel crashes. I have Automatic Calculation switched off, so I don't understand why my system would have so much to do. Can anybody explain why this occurs? The file size is just over 55 mb. My PC has 128 mb of RAM.

Frank
 
Status
Not open for further replies.

Similar threads

bkoopers
  • Locked
  • Question
Problem with Excel pasting into filtered cells
Replies
1
Views
309
combo
combo
Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
518
mintjulep
M
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
455
SkipVought
S
renigar
  • Locked
  • Question
Having trouble with Excel Lookup
Replies
5
Views
883
renigar
renigar
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
680
Bijugate
Bijugate

Part and Inventory Search

Sponsor

Back
Top