Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Refreshing
This is probably quite a 'noob' question to most of you, but I have an excel
spreadsheet set up for a month by month profit and loss that uses formulas to calculate subtotals/totals/balances both accross and down for me. However when I enter or edit information into the cells that the formulas relate to, the totals do not update, it isn't until I actually edit and then accept the formula cell afterwards that the updated value appears. If I happen to miss 'updating' the formula in one cell then all other balances remain as were previously calculated. This is quite frustrating and I'm sure there is just an option or something that I'm missing somewhere. Please help. |
#2
|
|||
|
|||
Try this from the Excel main menu:
ToolsOptionsCalculation.....Select "Automatic". (You probably have "Manual" selected) Does that help? Regards, Ron "j_aguar_1981" wrote in message ... This is probably quite a 'noob' question to most of you, but I have an excel spreadsheet set up for a month by month profit and loss that uses formulas to calculate subtotals/totals/balances both accross and down for me. However when I enter or edit information into the cells that the formulas relate to, the totals do not update, it isn't until I actually edit and then accept the formula cell afterwards that the updated value appears. If I happen to miss 'updating' the formula in one cell then all other balances remain as were previously calculated. This is quite frustrating and I'm sure there is just an option or something that I'm missing somewhere. Please help. |
#3
|
|||
|
|||
Yes it did Ron, thank you very much for your help, I knew it would be an
option or something I'd missed somewhere. Regards, Jason "Ron Coderre" wrote: Try this from the Excel main menu: ToolsOptionsCalculation.....Select "Automatic". (You probably have "Manual" selected) Does that help? Regards, Ron "j_aguar_1981" wrote in message ... This is probably quite a 'noob' question to most of you, but I have an excel spreadsheet set up for a month by month profit and loss that uses formulas to calculate subtotals/totals/balances both accross and down for me. However when I enter or edit information into the cells that the formulas relate to, the totals do not update, it isn't until I actually edit and then accept the formula cell afterwards that the updated value appears. If I happen to miss 'updating' the formula in one cell then all other balances remain as were previously calculated. This is quite frustrating and I'm sure there is just an option or something that I'm missing somewhere. Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |