Hi,

Have you tried? I have no problem keeping the links. If you are using
tables the formulas, if you create them by pointing and clicking look like

=Table2[[#This Row],[Country]]

You must link the title row separately but the other row and column formulas
can be copied and pasted.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Eric" wrote:

Can I keep linked cells between sheets when using tables and sorting of those
tables?

For example, when I reference a cell that is in a table in "Sheet1" to
"Sheet2" and then I sort the table in "Sheet1" I will lose the link in
"Sheet2". Is there a way to keep these links when sorting tables even though
the referenced cells change the number position in the sheet?