| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving cells without changing their formulas | Excel Worksheet Functions | |||
| Moving cells without changing the formulas | Excel Discussion (Misc queries) | |||
| Changing values of x-axis to include greek letters | Charts and Charting in Excel | |||
| sort data without formulas in other cells changing? | Excel Discussion (Misc queries) | |||
| Can auto number (or OFFSET) include letters? | Excel Worksheet Functions | |||
Hybrid Mode
