Hi all,

I am looking for a clean and fast method (for 2010) to copy with links a bunch (10) of worksheets (same column formats but with different ammount of rows) and concatenate into a central DATA sheet to be able to run pivots on.

In the past (before 2010) I had the following but this for some strange reason took forever to finish when running in macro mode in 2010. In debug mode (F8) seemed to run normally though.

Sheets("DESIGN").Activate
Range("A" & MyRowPaste).Select
ActiveSheet.Paste Link:=True
Currently have the following running with very good speed (but without the links):

Sheets("DESIGN").Activate
Range("A" & MyRowPaste).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
How do I turn on the pasting with links again while maintaining the speed?