| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My current formulas in documents have quit working
When I make a change in a column that needs to be calculated, excel is not
updating the formulas, subtotals, or totals, etc. Also, you can enter a formula and then click and drag the formula to do a copy. If you click in the cells you copied the formula to, the formula is there in each cell, but it doesn't work. Could I possibly have a virus in just excel? All of my documents have been effected. Even if I create a NEW document, I have the same issues with formulas! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My current formulas in documents have quit working
ToolsOptionsCalculation tab, check Automatic
-- Kind regards, Niek Otten Microsoft MVP - Excel "Clark" wrote in message ... When I make a change in a column that needs to be calculated, excel is not updating the formulas, subtotals, or totals, etc. Also, you can enter a formula and then click and drag the formula to do a copy. If you click in the cells you copied the formula to, the formula is there in each cell, but it doesn't work. Could I possibly have a virus in just excel? All of my documents have been effected. Even if I create a NEW document, I have the same issues with formulas! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My current formulas in documents have quit working
Hi,
Try Tools|Options-Calculation tab and select automatic Mike "Clark" wrote: When I make a change in a column that needs to be calculated, excel is not updating the formulas, subtotals, or totals, etc. Also, you can enter a formula and then click and drag the formula to do a copy. If you click in the cells you copied the formula to, the formula is there in each cell, but it doesn't work. Could I possibly have a virus in just excel? All of my documents have been effected. Even if I create a NEW document, I have the same issues with formulas! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hyperlinks quit working | Excel Discussion (Misc queries) | |||
| control+arrow key quit working | Excel Discussion (Misc queries) | |||
| my password quit working in an excel workbook, help! | Excel Worksheet Functions | |||
| my excel formulas have quit working | Excel Worksheet Functions | |||
| calculations quit working | Excel Discussion (Misc queries) | |||
Linear Mode
