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.

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?

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.