ExcelBanter - Copy formulas not working

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Copy formulas not working (https://www.excelbanter.com/excel-worksheet-functions/147873-copy-formulas-not-working.html)

Dave Stitz

Copy formulas not working

I am trying to copy simple formulas in a spreadsheet and Excel appears to
only be copying the values. But when I go to the cell, it has the correct
formula, but the wrong result. I have not seen this before...can anyone
help?? The formula I copy has the same result in ever cell but they are
wrong.

Frustrated.

David Biddulph[_2_]

Copy formulas not working

Tools/ Options/ Calculation:
se it to Automatic.
--
David Biddulph

"Dave Stitz" wrote in message
...
I am trying to copy simple formulas in a spreadsheet and Excel appears to
only be copying the values. But when I go to the cell, it has the correct
formula, but the wrong result. I have not seen this before...can anyone
help?? The formula I copy has the same result in ever cell but they are
wrong.

Frustrated.

All times are GMT +1. The time now is 04:12 PM.