Replacing tabs in excel when those tabs are referenced in formulas
Posted on 2013-06-18
I have a tab in my excel workbook that other tabs reference. I have to replace this tab each week with the current version. i can either copy/paste the data from the new tab into the existing one. Or I can copy the entire tab from the new spreadsheet into the workbook and ensure the tab names are correct. I can do either.
Here's my problem. As soon as I delete the tab/data that the formulas were using, the entire spreadsheet that referenced any of those cells return "REF!" in the formulas.
Can I turn off automatic calculate or something like that to prevent this from happening each week?