Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

excel formular problem

Comment:

Not sure what I am doing wrong? In excel, I have a list of numbers (eg2,3,4). I then use the sum formula to add the numbers (answer 9), but when I change one of the numbers (eg2,4,4) my answer doesnt automatically update to 10 like I need it to

Reply:

Excel questions are best asked in the Office Software forum. MIKE http://www.skeptic.com/

0

Name: AlwaysWillingToLearn
Date: October 6, 2009 at 07:42:36 Pacific

Reply:

This usually happens when the Automatic Calculation option is disabled. To Enable this Office 2003: Tools >> Options - Should be able to find a option there called 'Workbook Calculation' - Enable it to AUTOMATIC Office 2007: Hit the Office Button - Excel options (down the bottom) - Under 'Formulas' enable 'Workbook Calculation to ' AUTOMATIC.

0

what is dllcache

Login Password Box No Lon...

Summary: I ran into an Excel printing problem with duplex and solved the problem by installing a separate printer driver with duplex enabled by default. If you are changing the paper tray from within Excel's p...

Summary: I have seen that this is a known problem when bringing old Excel Macros to Office XP. My understanding is if you wrote the macro in VB through the editor it will not work, if you recorded it through ...

Summary: Hii.. in my Excel sheet chart the legends are not coming.. i opened the same file in another system which is showing that legends. i am using msoffice2002. the another system is msoffice 2002. if rein...