Microsoft Excel 2010 How to reference a table to another sheet

You copy and then right click paste special and link is at the bottom, it's a button in 2010

Alternatively, it should be in your paste menu when you right click:

It's the one that looks like a chain (link) or an infinity symbol

Microsoft Excel is not able to reference a Table with reference / link to another sheet. It only worked with Range.

With range you can reference like this. Sheet1!$A$1

But it is not possible with Table.

The answer from @Raystafarian does not work when selecting the whole table. For some reason Excel doesn't allow the paste with links. However it can be done by copying it twice, first time with only headers and second time with only data. I don't get that.