Copy/Paste very slow with separate excel window

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NicoleA - 28 Jun 2005 21:11 GMT

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.

Reply to this Message

CLR - 29 Jun 2005 01:46 GMT

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

> 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
[quoted text clipped - 4 lines]
> 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.

Reply to this Message

NicoleA - 29 Jun 2005 12:39 GMT

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

> Try this way.........
>
[quoted text clipped - 17 lines]
> open
> > for some reason. Not my place to argue with them.

Reply to this Message

CLR - 29 Jun 2005 16:16 GMT

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

> 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
[quoted text clipped - 27 lines]
> > open
> > > for some reason. Not my place to argue with them.

Reply to this Message