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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

emeraldc - 22 May 2008 16:03 GMT

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.

Reply to this Message

Bernard Liengme - 22 May 2008 16:07 GMT

Give us an exmple of before and after
best wishes

Signature

Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

> Excel keeps auto-changing my formulas to include other nearby cells. How
> can
[quoted text clipped - 4 lines]
> changes it. I don't kow how to stop this from happening and I can't find
> anything that helps me with this problem.

Reply to this Message

Niek Otten - 22 May 2008 16:12 GMT

Tools>Options>Edit tab, Uncheck "Extend data range formats and formulas"

Signature

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.

Reply to this Message