I have two spreadsheets A and B both with multiple tabs. Spreadsheet B in
linked to Spreadsheet A. I changed the name of one of the tabs in spreadsheet
A with out having B open. When i opened up B I notice a ton of "#REF"
symbols. This is because the tabs name that it is looking for is no longer
availible. Is there a way to update this has a whole instead of having to
link all 500 cells individually.