Excel

[Riccardo_Magliocchi]

Do you know if it is possible to copy and paste a table with formulas, without changing the formula references (i.e. like cut and paste, without actually cutting the original table)?

[#2]

@Riccardo_Magliocchi 

Have you tried to Copy and then paste using any of the options on the Paste....Special.... Dialog box? 

[#3]

@mathetes 

Hello Mathetes,

I tried but I could not find any suitable options. The only way was to use F4 to fix the references in the original formulas.

Thanks and best regards,

Riccardo

[#4]

@Riccardo_Magliocchi 

It is so long since I have used a relative reference that I have forgotten the behaviour (I only use arrays and lists)!  I now have a feeling of shock when duplicating a formula generates different results.

A strategy of last resort might be Ctrl/H to replace equals '=' by backslash '\' and then copy the formula as dumb text.  Returning the '\' to '=' reinstates the formulas as they were.  A similar strategy could be to use FORMULATEXT in some scratch area and then Copy/Paste values.  You could still need 'text to columns' to commit the resulting text as a formula.