Hi guys,

which one do you rather when the data resides in a worksheet from another workbook?

To import a worksheets content or to open the other workbook, copy its content and past it where you want?

Which one is the best and faster?

I have been doing this very often and always believed that to import is best, but now I am having serious problems on doing this.

I am trying to import a worksheet with subtotals and filters and I dont know why I am loosing many rows in the process.

Then I tried to copy the worksheets content and paste it where I want it. Bang again, frozen machine.

The worksheet I am trying to import is HUGE (48,5 Mb).

Any suggestions?