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?
I am assuming you keep a copy of the current tab in the file for archive purposes but want your data to reference the new one. Try this:
: Copy the entire current tab (not using copy cells, but by right