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

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.
 
N

Niek Otten

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cells not updated automatically 3
Word doc keeps changing to ALL CAPS 0
Auto Change Formulas - Please Help. 2
Excel does not accept text format! 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Excel help needed: Skipping cell without skipping cell reference 1
Auto Sum not working correctly 1
offset formula causing Circular reference 0

Top