PC Review


Reply
Thread Tools Rate Thread

Calculations that were working are now not.

 
 
Cycleaway
Guest
Posts: n/a
 
      18th Jun 2008
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 With Quote
 
 
 
 
Bob I
Guest
Posts: n/a
 
      18th Jun 2008
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?


 
Reply With Quote
 
Kevin B
Guest
Posts: n/a
 
      18th Jun 2008
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Working with time calculations Gotroots Microsoft Excel Worksheet Functions 3 6th Jan 2010 10:52 AM
Worksheet Calculations not working KPA Microsoft Excel Worksheet Functions 4 3rd Feb 2009 05:13 PM
calculations not working Jo Microsoft Excel Worksheet Functions 4 7th Jun 2008 12:18 AM
Working Day calculations =?Utf-8?B?V09PREE=?= Microsoft Access VBA Modules 1 30th Aug 2006 01:45 PM
calculations quit working =?Utf-8?B?Q0o=?= Microsoft Excel Misc 24 17th Nov 2005 06:09 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:50 PM.