Changing where a Table "refers to"

[michellepace]

I have opened my name manager and found that for Tables in particular you cannot Edit the "refers to" range.

I have a spreadsheet which uses "varsTable" in about 18 different places. I no longer want to use this table but rather a table which is located in a seperate workbook, called centralVarsTable.

Question: What is the easiest way for me to make my spreadsheet refer to this external table?

[Olly]

Use Find and Replace

[michellepace]

Thanks Olly for your prompt reply. I thought of Find&Replace which would be fine if I were simply replacing the name of my Table for a second table contained in the same workbook. My problem is what to use in the "replace" when centralVarsTable is in another worbkook called aaa.xlsx on Sheet1 ... how do I refer to that that particular table then?

[Olly]

Find what: varsTable
Replace with: aaa.xlsx!centralVarsTable