References to a table that does not exist temporarily.

[HighAndWilder]

I often have to replace a table of data in a worksheet that is referenced elsewhere.

How do I stop getting the #REF! error in the cells that reference the table?

Thanks

 

[6StringJazzer]

How are you "replacing the table"? By "replace a table of data" do you mean that you just need to replace the data in the table? If so there is no need to delete the table, just paste over the data. That will not affect any references to it.

What is the formula in the cells that reference the table?