Dashboard: updating data in the data worksheet

[Smitty15]

I have special situation where information is housed in a separate system and need to export this data from time to time to update the data in my "data" worksheet of my dashboard.


If I delete the current worksheet titled "Data" and import a new worksheet and title it "Data", will the formulas automatically adjust to this new worksheet?


Any solutions?

 

[keymaster]

deleting existing worksheet will not work as it makes all the references #REF!


You should try to establish a connection between data sheet and external system or manually copy paste values (or write a macro to do this automatically).

 

[kchiba]

You should separate the input area from the calculation ares, either on different sheets or different parts of the data sheet