| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculations that were working are now not.
I have made a multi page form for work with mostly drop down menus and
vlookups. It was working well. Now I can not get the fields to update and calculate. When I look at the formulas they are stated correctly, and the value shows what I want in the formula message box. How ever the page does not show the results? It is like the formulas are waiting to calculate. How do I correct this? -- Try riding a bike to work. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculations that were working are now not.
perhaps Auto Calc got turned off? (Tools, Options, Calculation, auto)
Cycleaway wrote: I have made a multi page form for work with mostly drop down menus and vlookups. It was working well. Now I can not get the fields to update and calculate. When I look at the formulas they are stated correctly, and the value shows what I want in the formula message box. How ever the page does not show the results? It is like the formulas are waiting to calculate. How do I correct this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculations that were working are now not.
Click TOOLS in the menu and select OPTIONS. Click the CALCULATIONS tab and
reset the calculation method from MANUAL back to AUTOMATIC -- Kevin Backmann "Cycleaway" wrote: I have made a multi page form for work with mostly drop down menus and vlookups. It was working well. Now I can not get the fields to update and calculate. When I look at the formulas they are stated correctly, and the value shows what I want in the formula message box. How ever the page does not show the results? It is like the formulas are waiting to calculate. How do I correct this? -- Try riding a bike to work. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculations not working | Excel Worksheet Functions | |||
| Making weekend days working days - the system cuts the working tim | Excel Discussion (Misc queries) | |||
| Fomulas and calculations are no longer working on my Excel Spreads | Excel Worksheet Functions | |||
| calculations quit working | Excel Discussion (Misc queries) | |||
| excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
Linear Mode
