Copying formula's from one table to another!

[Kirnon]

Whenever copying a formula such as =[@[Mar Fcast]] from one table to a new table with the same headings (obviously), the copy always changes to =Table1[@[Mar Fcast]].

Am I missing something that will allow me to copy a formula so that it only pulls exactly and doesn't attempt to reference the old table?

Or do I have to continue to suffer using REPLACE after each new table created?

Many thanks.

 

[Gian624]

Instead of copying the formula from the cell, try copying the formula from the fx bar at the top (the line of text that shows up at the top of the screen under the ribbons that shows you what is in the cell you click on). Then when you paste it to the next table, click on the cell you want to paste it to and then paste it in the same fx bar insted of in the cell.