Out of Memory - Not enough memory to continue

Kevin Mac · Feb 22nd, 2002, 01:01 PM

Hey folks, I am running into a real headache in Excel 2000, I am on Windows 2000 across a WINNT network. I am trying to copy and paste 24 columns of data with 500 rows of related data from one workbook to another. The file size of the target file is 1.26MB and the Source file is 2.27MB. I have a 384MB page file, and 260 MB of Ram. This is on a 1.4mz Pentium 4 client machine. I have installed service pack 2 for Office 2000 due to some related issues, and those have been resolved. Any suggestions guys???

RWinfield · Feb 22nd, 2002, 04:07 PM

Could it be that you have found the limitation of the clipboard? If I remember correctly the clipboard is limited to 65,000 bytes, same as notepad. You will get that error in notepad if the file you are attempting to paste to is too large. Maybe try pasting 100 rows at a time and see if that works.

Rick

MrExcel · Feb 22nd, 2002, 10:30 PM

This doesn't sound like enough to be a clipboard issue. I ran into a problem this week while trying to copy a worksheet that had over 1 million cells. There is a documented Excel 2000 bug when trying to copy a worksheet with 1 million + cells - that gives a "Disk Full" error.

Jack in the UK · Feb 23rd, 2002, 02:16 AM

Hi

JUST TO ADD TO THAT MrExcel is correct but i beleave it only if so many cells contain data

Tghat is if you celect all in a fairly light sheet and copy to another should be OK, but if 1 million cells used problem arised.

Rdgs
==========
Jack

Feb 22nd, 2002, 10:30 PM	#3
MrExcel . Join Date: Feb 2002 Location: Akron, Ohio USA Posts: 789	This doesn't sound like enough to be a clipboard issue. I ran into a problem this week while trying to copy a worksheet that had over 1 million cells. There is a documented Excel 2000 bug when trying to copy a worksheet with 1 million + cells - that gives a "Disk Full" error. __________________ Preview my latest book for Free

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 22nd, 2002, 01:01 PM	#1
Kevin Mac New Member Join Date: Feb 2002 Posts: 8	Hey folks, I am running into a real headache in Excel 2000, I am on Windows 2000 across a WINNT network. I am trying to copy and paste 24 columns of data with 500 rows of related data from one workbook to another. The file size of the target file is 1.26MB and the Source file is 2.27MB. I have a 384MB page file, and 260 MB of Ram. This is on a 1.4mz Pentium 4 client machine. I have installed service pack 2 for Office 2000 due to some related issues, and those have been resolved. Any suggestions guys???

Feb 22nd, 2002, 04:07 PM	#2
RWinfield New Member Join Date: Feb 2002 Location: Washington State Posts: 33	Could it be that you have found the limitation of the clipboard? If I remember correctly the clipboard is limited to 65,000 bytes, same as notepad. You will get that error in notepad if the file you are attempting to paste to is too large. Maybe try pasting 100 rows at a time and see if that works. Rick

Feb 23rd, 2002, 02:16 AM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,064	Hi JUST TO ADD TO THAT MrExcel is correct but i beleave it only if so many cells contain data Tghat is if you celect all in a fairly light sheet and copy to another should be OK, but if 1 million cells used problem arised. Rdgs ========== Jack