Any way to copy the data in a table without copying the table?

[#1]

Hi, I have a table that has a couple of input fields, and expressions for totals, and I want that data for another sheet. I went with copying the table, naming it the same object id, but the problem with that is any changes to the second table affect the first, and this is a problem as I want to add new columns, and hide some of the ones from the original table. Is there any way to do this? Just reference the rows/columns in first table, while I add new ones? Thanks

[MarcoWedel · Accepted solution]

Don't create a linked copy, but paste as seperate sheet object:

Copy the marked table object

and select "Paste Sheet Object" in the context menu anywhere on the sheet.

This way you get another Object ID i.e. changes of the pasted table should not affect the source table.

hope this helps

regards

Marco

[#3]

Awesome thanks works perfectly! For some reason I thought I couldnt do this without linking back to it in some way. It even brings over the calculated expressions and the input fields. Awesome.