• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dashboard: updating data in the data worksheet

Smitty15

New Member
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?
 
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).
 
You should separate the input area from the calculation ares, either on different sheets or different parts of the data sheet
 
Back
Top