Copy paste slows down
 

Hi Dave,

Thanks for your suggestion, but no luck this time - the problem still occurs.

After some more playing around, I have noticed that this same problem does
not occur when copying and pasting data from other worksheets that contain
lots of formulas.

It seems that my problem is specific to the worksheet I am copying from (in
the example I gave before, this it the 'EventLog' worksheet), which makes me
less confident that someone else may have had this problem before.

I'll keep looking but any more help would definately be appreciated.

Cheers,

David

Copy paste slows down
 

Hi all,

A bit of an update...

I have noticed that the worksheet I am copying and pasting has a very large
amount of formulas which link to another worksheet. I found that if I remove
these formulas, the problem is solved i.e. the looping copy/paste operation
from my first post does NOT slow down over time. This is great - this is what
I am after.

Therefore, it seems to me that if I copy and paste the worksheet when the
formulas are present, Excel tries to recreate the formula dependency tree or
something like that. Over time, this tree recreation process gets
progressively slower, despite that Application.Calculation is set to manual.

So, what I need now is some way of temporarily 'turning off' these formulas
during the copy/paste process. For example, I could rattle through the
worksheet and insert a character (e.g. '!') in front of the formulas,
essentially converting them to strings. Its just that this takes too long to
do (and then undo).

Is there any extremely quick way to stop this behaviour???

Please help!!!

David