Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
excel formula changes without user input?
I have a budget sheet that references multiple sheets (i.e. the first sheet is the summary of each following sheet which are broken down into months). The problem I'm having is that the summary sheet is supposed to calculate sum totals of fields on ONLY that summary sheet. But every time I change something on the following monthly sheets, the formulas on the front sheet change, and it tallies up some of the cells from the monthly sheets, instead.
I'm thinking there has to be a way to completely lock the cell from any changes (on the summary sheet).
Please Help!
To make the problem more clear: The summary sheet is supposed to tally only items that are on the summary sheet itself.
Those fields that are tallied should look like this (i.e. =-ABS(SUM(B9:B20)))
And they do look like that for the first cell (January)
But when I change values in the monthly cells, they change to this: =-ABS(SUM('PFCU Feb'.A99:'PFCU Feb'.A110))
So, as you can see the Summary range changes and then calculates these values from a summary range that is on the monthly sheets. To make things even more complex, the formulas that change are only on the summary sheet, and do not correspond to the monthly tally sheet that was edited, or sometimes sorted differently.
It's always Feb, Mar, and Apr that change on the summary sheet.
1 Answer
- expletive_xomLv 79 years agoFavorite Answer
sounds like your summary sheet is working rpoperly.
it seems like the summary sheet is summarizing the monthly sheets. when you make changes to the monthly detail, the summary sheet updates.
you should talk to the person that gave you the file and explain that you are trying to change the monthly numbers...or whatever you are trying to do....and ask if you are doing your work right.
or make a change in your monthly sheet....then click on the cell in the summary sheet thats changing...and take a look at the formula. maybe get rid of the formula.
or you can turn off the automatic recalculation. (in excel 2003 its n the tools>options menu) and change t to Manual Recalculate (F9 Key)
or maybe look into "Trace dependents" function. that draws arrows that shows how formulas are effected by the cells you want to change.
good luck
