Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add further info into a column containing a formula
Hi I have a spreadsheet which has been in use successfully for a year. The
calculations are mostly simple additions down columns. In the past I could enter a new value and it would automatically be included in the total cell at the bottom of that column. Now the new value can be entered but is not included in the total cell. I have checked that the input cell is part of the formula. It is as if the spreadsheet has become locked in some way? Nobody else has access, have I ticked a box somewhere by mistake? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I add further info into a column containing a formula
Tools/ Options/ Calculation:
Make sure it says Automatic, not Manual. -- David Biddulph "weejb" wrote in message ... Hi I have a spreadsheet which has been in use successfully for a year. The calculations are mostly simple additions down columns. In the past I could enter a new value and it would automatically be included in the total cell at the bottom of that column. Now the new value can be entered but is not included in the total cell. I have checked that the input cell is part of the formula. It is as if the spreadsheet has become locked in some way? Nobody else has access, have I ticked a box somewhere by mistake? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
Consolidate information from Column B Based on Info In Column A | Excel Worksheet Functions | |||
How do I sort by info in one column and it stay in line with info | Excel Worksheet Functions | |||
Using a date range in a formula to pull info to the correct column | Excel Worksheet Functions | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) |