Software

Ask something
Discussion Locked

Office 97 Excel

0 helpful
7 replies

by sfolsom

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to move a considerable amount of information from worksheet to another (about 1400 rows but only 6 or 7 columns. My dilema is that when I copy this to the clipboard I get a message that the virtual clipboard is just about full. Is there a way to get rid of this annoyance when I move my data at the end of every week?

7 replies

by highlander718

If you are doing this weekly, why don't you just link the cells from the "new "sheet to the other one ("original" one) ? So you don't have to do anything, not even copy !

by highlander718

More specificaly, being in the "new" shit select the left-upper cell, hit "=" and than select the first left-upper cell of the original table. After that you can position your mouse in the right-lower corner of the "new" cell and drag 1400 rows downand 3-4-5 columns to the right or whatever.

by sankulpune

Hello,

I tried to simulate your problem. I had a problem, not of error message but of the system getting hanged.
1) The problem relates not to the no. of rows or columns but of the total amount of data being copied.
2) To overcome this problem increase the amount of RAM available by vartious standard ways :

Closing down applications.
Making more disk space by deleting files
etc.

If nothing works you may need to install more RAM.

With regards,

SanganakSakha.
Simple And Effective Solutions To Small problems, No QuickFixes.

This discussion is closed to new replies.