Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / March 2006

Tip: Looking for answers? Try searching our database.

Calculations not changing in cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
donnad - 29 Mar 2006 00:07 GMT
I am editing numbers in cells but when I do, the spreadsheet does not
recalculate the new total at the bottom of the column even though formula was
working correctly yesterday.  Also, I put number in column
(ex:        Column G      Column H
row35      2500           formula (=g35*6)  should calculate $15000 - it is
correct
row36      1000           formula (=g36*6)  should calculate $6000 but
calculates   $15000

I emailed the spreadsheet to my assistant to see if she could work with it
and the spreadsheet works correctly on her pc.
Pete_UK - 29 Mar 2006 00:28 GMT
Check out Tools | Options | Calculation (tab) - you might have this set
to manual, so change it to automatic, then OK.

Hope this helps.

Pete
davesexcel - 29 Mar 2006 00:32 GMT
I am wondering if your excel is not set to automatic calculation

goto ,tools, options,calculate, set calculate to automatic

Hope this works

Signature

davesexcel

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.