Copy/Paste very slow with separate excel window

[Guest]

I have a spreadsheet with 32,000 rows and 15 rows. When I copy data from the
spreadsheet and click File New and then paste into the spreadsheet it is very
fast. BUT when I launch another Excel instance and do a paste it is very
slow. Now if I delete about 15,000 rows, the copy/paste is faster. Is there
some sort of limitation of Windows 2000/xp or Excel. IT happens in Excel
2000 and 2003 versions. This is for our customer service department who
works in Excel all day and they say they must have several Excel windows open
for some reason. Not my place to argue with them.

 

[CLR]

Try this way.........

Right-cick on the SheetTab you want to copy to a new book, then >
MoveOrCopy > ToBook: (new book) > check the CreateAcopy box >
OK..................any faster?

Vaya con Dios,
Chuck, CABGx3

 

[Guest]

No, it was not any faster. All I want to do is copy about 3 cells from our
main spreadsheet into a new Excel sheet in a SEPARATE EXCEL INSTANCE. Is
there a limitation on size of spreadsheets or number of rows? The main
spreadsheet is 16mb and has 32,000 rows with 15 columns.. OUr users need only
to copy a few cells out of it into a new excel window. (if they do it in the
same excel instance by doing a file - new.. it is fast. But launch another
instance of excel.. it is very slow.. like 20 seconds). Checked memory and
disk space and all very good there.
Nicole

 

[Guest]

Could perhaps some sort of "autosave" process be taking place triggered by
the copy/paste execution........maybe a "change-event" macro?

Vaya con Dios,
Chuck, CABGx3