| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formuals not working in existing workbooks
All of a sudden the existing formulas do not work in my worksheets. If I copy
a cell and paste to another cell, it just paste's the value of the copied cell and not the formula. Or if it copies the formula, it show's the right cells to reference but the value is the copied cell value. If I open a new workbook, this does not happen and everything is fine. Any suggistions? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formuals not working in existing workbooks
Hi Tom
Sounds as though ToolsoptionsCalculation has been set to Manual for that workbook. Change it to Automatic -- Regards Roger Govier "Tom" wrote in message ... All of a sudden the existing formulas do not work in my worksheets. If I copy a cell and paste to another cell, it just paste's the value of the copied cell and not the formula. Or if it copies the formula, it show's the right cells to reference but the value is the copied cell value. If I open a new workbook, this does not happen and everything is fine. Any suggistions? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formuals not working in existing workbooks
Well the second problem sounds like calculation is set to Manual. Choose
Tools, Options, Calculations, Automatic. I'm not sure what is happening in the first part of your question, please show an example: Cell A1 contains =B1 and B1 contains the text "Test", when A1 is copied to A2, A2 contains the text Test but no formula? -- Thanks, Shane Devenshire "Tom" wrote: All of a sudden the existing formulas do not work in my worksheets. If I copy a cell and paste to another cell, it just paste's the value of the copied cell and not the formula. Or if it copies the formula, it show's the right cells to reference but the value is the copied cell value. If I open a new workbook, this does not happen and everything is fine. Any suggistions? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formuals not working in existing workbooks
Thank you VERY much. Do you know of any reason this would have changed to
manual by itself? I have not entered that area before. "ShaneDevenshire" wrote: Well the second problem sounds like calculation is set to Manual. Choose Tools, Options, Calculations, Automatic. I'm not sure what is happening in the first part of your question, please show an example: Cell A1 contains =B1 and B1 contains the text "Test", when A1 is copied to A2, A2 contains the text Test but no formula? -- Thanks, Shane Devenshire "Tom" wrote: All of a sudden the existing formulas do not work in my worksheets. If I copy a cell and paste to another cell, it just paste's the value of the copied cell and not the formula. Or if it copies the formula, it show's the right cells to reference but the value is the copied cell value. If I open a new workbook, this does not happen and everything is fine. Any suggistions? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formuals not working in existing workbooks
If you had opened a file earlier which had been saved with the manual
calculation option set, then all other files opened in that same instance of Excel would inherit this setting. Pete On Jan 26, 6:33 pm, Tom wrote: Thank you VERY much. Do you know of any reason this would have changed to manual by itself? I have not entered that area before. "ShaneDevenshire" wrote: Well the second problem sounds like calculation is set to Manual. Choose Tools, Options, Calculations, Automatic. I'm not sure what is happening in the first part of your question, please show an example: Cell A1 contains =B1 and B1 contains the text "Test", when A1 is copied to A2, A2 contains the text Test but no formula? -- Thanks, Shane Devenshire "Tom" wrote: All of a sudden the existing formulas do not work in my worksheets. If I copy a cell and paste to another cell, it just paste's the value of the copied cell and not the formula. Or if it copies the formula, it show's the right cells to reference but the value is the copied cell value. If I open a new workbook, this does not happen and everything is fine. Any suggistions?- Hide quoted text -- Show quoted text - |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formuals not working in existing workbooks
The default on the setting is Automatic. Maybe another user set it to
manual? If there are any macros in the workbook, they may have set the option. When I write macros I often have them set this option to manual because the macros run faster in many cases, however, the author of the macro must make sure that they turn the option back on in the code. -- Cheers, Shane Devenshire "Tom" wrote: Thank you VERY much. Do you know of any reason this would have changed to manual by itself? I have not entered that area before. "ShaneDevenshire" wrote: Well the second problem sounds like calculation is set to Manual. Choose Tools, Options, Calculations, Automatic. I'm not sure what is happening in the first part of your question, please show an example: Cell A1 contains =B1 and B1 contains the text "Test", when A1 is copied to A2, A2 contains the text Test but no formula? -- Thanks, Shane Devenshire "Tom" wrote: All of a sudden the existing formulas do not work in my worksheets. If I copy a cell and paste to another cell, it just paste's the value of the copied cell and not the formula. Or if it copies the formula, it show's the right cells to reference but the value is the copied cell value. If I open a new workbook, this does not happen and everything is fine. Any suggistions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| How to merge monthly workbooks into a quarterly workbook?? | Excel Worksheet Functions | |||
| Sharing Linked Workbooks | Excel Discussion (Misc queries) | |||
| Working on Multiple Workbooks | Excel Discussion (Misc queries) | |||
| How can I get existing Excel workbooks to open in separate windows | Excel Worksheet Functions | |||
Linear Mode
