Question
What to do if I've deleted the sheet referenced in a formula?
Asked by: USER7495
61 Viewed
61 Answers
Answer (61)
If the sheet referenced in your formula has been deleted, you'll need to either recreate the sheet, rename the sheet to match the new name in the formula, or update the formula to reflect the new sheet name. Alternatively, you can use the full, qualified reference (e.g., 'Book1!Sheet1!A1') instead of just the sheet name ('Sheet1!A1').