| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Freezing an auto update field
Hi all,
I've set up a spreadsheet to update from a formula. The spreadsheet is designed to track monthly information and does that well, but the formula is allowing(causing?) these cells to change even after that month is passed. i.e: Jan = $275 Feb = $325 Mar = $300 Apr = $450 Total = $1,350 With the formula setup, after a certain total is reached, Jan ='s $315, Feb = $364... I want the totals to remain static after they are figured and not to adjust as changes are made later. Does anyone know of an easy way to accomplish this? TIA, Byron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I create an auto update chart in a template | New Users to Excel | |||
| Sum range auto update | Excel Worksheet Functions | |||
| Excel auto filter does not show all choices for the field? | Excel Discussion (Misc queries) | |||
| How do I get a field in excel to auto complete with a check mark | Excel Discussion (Misc queries) | |||
| How do I make a name formula auto update in Excel | Excel Worksheet Functions | |||
Linear Mode
