I've 2 sheets linked, the source file helps me auto populate data in the other one.
What are the basic precautions I need to keep in mind, that the sheet which gets auto populate does not lose the formula.
The source file gets updated by several people and keeps traveling over email.
My guess is:
I need to make sure that the name of both should not change.
Will the file in a folder on my desktop get populated if someone else is updating the master at their work station? If not, will it get updated when I get the Master back and paste it in the designated folder on my system?
How does this work is all I want to know, as I've already applied all formula?