Excel keeps auto-changing my formulas to include other cells.
 

Excel keeps auto-changing my formulas to include other nearby cells. How can
I create and save a formula in a spreadsheet without the program changing my
formula? Each day I have to correct the formula because Excel automatically
changes it. I don't kow how to stop this from happening and I can't find
anything that helps me with this problem.

Excel keeps auto-changing my formulas to include other cells.
 

Give us an exmple of before and after
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"emeraldc" wrote in message
...
Excel keeps auto-changing my formulas to include other nearby cells. How
can
I create and save a formula in a spreadsheet without the program changing
my
formula? Each day I have to correct the formula because Excel
automatically
changes it. I don't kow how to stop this from happening and I can't find
anything that helps me with this problem.

Excel keeps auto-changing my formulas to include other cells.
 

ToolsOptionsEdit tab, Uncheck "Extend data range formats and formulas"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"emeraldc" wrote in message ...
| Excel keeps auto-changing my formulas to include other nearby cells. How can
| I create and save a formula in a spreadsheet without the program changing my
| formula? Each day I have to correct the formula because Excel automatically
| changes it. I don't kow how to stop this from happening and I can't find
| anything that helps me with this problem.