Is there a way to quickly update all references within a sheet to another sheet?
Example: we have Sheet1, Sheet2 and Sheet3. Sheet2 contains formulas, pivot tables etc., all referencing Sheet1. We now want all these references to point to Sheet3 instead. Is there a quick way to do this or do we actually have to analyze every reference manually?