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

  • Thread starter Thread starter emeraldc
  • Start date Start date
E

emeraldc

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.
 
Tools>Options>Edit tab, Uncheck "Extend data range formats and formulas"

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| 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.
 
Back
Top