Pasting array with formula2 values gives me out of memory error

so i got this excel table i copy into a 2d array, i make some row modifications/additions and then paste it back to the same excel table.

The table has some formulas refering to the table row by name like the following:

Please Login or Register  to view this content.

as you can see in the attached, the moment i paste the array im getting out of memory error.

i dont get the error if my formula does not have named row refference like the following:

Please Login or Register  to view this content.

i tried all the following but no luck

Please Login or Register  to view this content.

idealy id like to keep the row named reference for obvious reasons. any ideas?

I managed to resolve the issue.
It seems that the problem was happening because i deleted the table data rows before pasting the array back. A table column reference was trying to be placed outside the table and excel complained with out of memmory. This is why when using the cell reference there was no problem.
So this time after deleting the table data rows, i resized the table to the array size and no problem any more... almost!

Formula:

Please Login or Register  to view this content.

However, even the array was correct, after beeing placed back to the table, excel was corrupting the referenced table columns of the same table inside the formulas for some reason!
so for example

Formula:

Please Login or Register  to view this content.

referencing a column in the same table
after paste was transformed into

Formula:

Please Login or Register  to view this content.

while

Formula:

Please Login or Register  to view this content.

referencing a different table column
remained correct.

any ideas how to force/trick excel to not corrupt the formula referencing columns of the same table?

thx!

Maybe?

Please Login or Register  to view this content.

hey, unfortunatly this results into

Formula:

Please Login or Register  to view this content.

!

hm i think i will proceed as follows
i will make the formula

Please Login or Register  to view this content.

which in turn results into

Please Login or Register  to view this content.

and after pasting the array i will replace "@Table_amounts" with "Table_amounts". It will always be the table name which needs to be corrected so its somewhat safe i guess

thx JEC. for givinng me the idea!

Actually after getting some advice from chatgtp and after some wrong proposals and fine tuning i got the ideal solution!
The moment of pasting the array back to excel should be

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

Apparently when using FormulaArray excel preserves the structured references and array formula syntax in contrast to .formula

so no need for replacing and no need for

Please Login or Register  to view this content.

Please Login or Register  to view this content.

is enough!