Duplicated sheet with table still brings in old table names in formulae in new rows

Hello all,

Thanks in advance for any assistance.

I have duplicated Sheet 1 which has a table in it called Table1, and renamed to Sheet 2.

The table in Sheet 2 I have changed to NewTable in the design tab.

When I add new rows to NewTable the formulae are still referencing Table1.

Please can someone tell me how to fix this?

Thank you

Paul

Hello, I just wanted to say I created a new Sheet (Sheet 3) and simply copy-pasted the whole of Sheet 2 into the new Sheet and it seemed to solve the problem.

There must be some glitch with regards to duplicating sheets and table-names. Regards.