Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
All of a sudden none of my Excel formulas are working...
I have simple Excel formulas (like sum a column). All of a sudden none are
working, in any spreadsheet I open. I must of hit something. What do I do? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
All of a sudden none of my Excel formulas are working...
you can start by checking if your workbook is set to automatic calculate goto tool,options,calculation, set calculate to automatic -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=531213 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
All of a sudden none of my Excel formulas are working...
If you get the formulas as text strings press ctrl + ` (grave accent) or
toolsoptionsview formulas; If they don't calculate tooloptionscalculation and set to automatic -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "Trina" wrote in message ... I have simple Excel formulas (like sum a column). All of a sudden none are working, in any spreadsheet I open. I must of hit something. What do I do? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
All of a sudden none of my Excel formulas are working...
Easy peasy once you know -- thank you so much
"davesexcel" wrote: you can start by checking if your workbook is set to automatic calculate goto tool,options,calculation, set calculate to automatic -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=531213 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
how can i get formulas in excel to copy and paste? | Excel Worksheet Functions | |||
Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Excel formulas and recalculation | Excel Discussion (Misc queries) | |||
How can I get EXCEL formulas to work in Works? | Excel Worksheet Functions |