I have 2 Excel documents.
The first document is named "data" and it extracts data from off the Internet every 24 hours.
The second document, named "database", is for storing this data. Every 24 hours, I run a macro which imports the data from "data" into a new row in "database", along with the date the macro was run.
My problem is this: Whenever I refresh the external data in "data", my "database" document also refreshes itself instantaneously.
My question is this: Is there a way to "cut the connection" between the two documents so that, when "data" is refreshed, the data in "database" DOES NOT also refresh itself automatically?
Thank you in advance![]()
Bookmarks