Stopping cells from automatically refreshing after external data refreshes

**UNWATCHABLE** · 01-30-2010, 10:42 PM

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

**teylyn** · 01-30-2010, 10:52 PM

There's something I'm not getting. You have a link between two documents, but you don't want the link? You run a macro every 24 hrs to update the data, but you don't really want to update?

You can set the link updating to manual on your "database" file. Or run the macro only on demand, not every 24 hrs.

Or explain a bit more ...

**UNWATCHABLE** · 01-30-2010, 11:21 PM

Sorry, I wasn't clear enough.

I want "data" to update every 24 hours as per normal. I then run a macro which, ONLY ONCE, uses the information in "data" to create an entry in my "database" file. (along with the date the macro was ran).

You see, the external data I import in "data" is a table with some useful, and some useless, information. When I refresh "data", it deletes the old data in the table, and puts in new data. It doesn't hold the old data. This is why I have "database", to store the old data.

Now, when I refresh "data", all entries in my "database" also update to the new data.

I don't want this! I want each row in "database" to hold historical data, not automatically-updated data!

If I haven't explained something clear enough please ask me to explain further

**UNWATCHABLE** · 01-30-2010, 11:36 PM

OK thank you Teylyn, I've sorted this problem out now.

In my "database" file, I selected the row I wanted to keep permanent, went to Data ---> Edit Links ---> Break link.

I'll add this link-breaking method into my macro, thanks