I have a sales spread sheet broken down by district and have linked formulas for each district that go back to the main data entry spread sheet. The problem I'm having is when a store changes districts I have to change all the linked formulas. What is the best/easiest way to make this type of change without changeing all the formulas?How to change linked worksheet formulas?In Excel 2003 just go to Edit %26gt; Links (from there it's pretty self explanatory on how to change all references to another sheet).
not sure about Excel 2007 but the option is there somewhere (maybe search the help topics to find where they moved the command to).How to change linked worksheet formulas?Open the properties/options for the links in the end sheet (the one that you are changing all the links in). You need to ensure that the data is created as a Link. (There is a checkbox for this.) As a link, the data in the end sheet will update anytime the original data is changed. Also, double check the origination source and ensure that the storage area is the same as the file that is being changed. It is possible you may be linked to a copy of the original file.
