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.

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?

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.