I wonder if anyone can help.

I have 2 separate excel files / that contain multiple worksheets. Within one of these worksheets is a macros that downloads some data from the web. I am trying to merge these 2 workbooks but when I do the macro then takes soooo long to download the data. In the initial sheet it works well and is quick.

Does anyone have any idea why this is and how I can fix it?

I have tried copying the worksheets from one workbook to the other in different ways but the same thing results.

Basically, there's one worksheet to copy across and I can't figure out why it won't work!

Thanks in advance!