I download data from internet, perform a half dozen routines to remove excess data, format data and so on. I then copy data to sheet 2. Works ok except the copied data has the internet connection in it. Using refresh all will cause new data to overwrite data in sheet 2. How can I copy data to sheet 2 without the connection or is there a macro method of removing these connections on sheet 2?