Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2003 not calculating
Hi All
Is there any particular thing that would stop excel from calculating. It was taking entries but formulas where not producing results and only previous results were being displayed. I have rebooted my spread sheet from a previous back up and all is now working . I am just a bit concerned it is something I did unknowingly Stew |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2003 not calculating
Tools Options... Calculation Automatic
-- Gary''s Student - gsnu200810 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2003 not calculating
Excel takes the Automatic/Manual calculation setting from the first Workbook
opend in that session. The setting can be changed without having to reboot by selecting: Tools Options Calculation and selecting Automatic. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "stew" wrote in message ... Hi All Is there any particular thing that would stop excel from calculating. It was taking entries but formulas where not producing results and only previous results were being displayed. I have rebooted my spread sheet from a previous back up and all is now working . I am just a bit concerned it is something I did unknowingly Stew |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2003 not calculating
THANKS EVERYBODY, DON'T KNOW HOW IT HAPPENED , BUT NOW I KNOW
STEW "Sandy Mann" wrote: Excel takes the Automatic/Manual calculation setting from the first Workbook opend in that session. The setting can be changed without having to reboot by selecting: Tools Options Calculation and selecting Automatic. -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "stew" wrote in message ... Hi All Is there any particular thing that would stop excel from calculating. It was taking entries but formulas where not producing results and only previous results were being displayed. I have rebooted my spread sheet from a previous back up and all is now working . I am just a bit concerned it is something I did unknowingly Stew |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
excel 2003 not calculating
You probably had the calculation mode set to manual - this setting can
be picked up from another workbook opened in the same Excel session. Click on Tools | Options | Calculation tab and check Automatic to return it to the usual setting, and then save your file. Hope this helps. Pete On Oct 29, 10:13*am, stew wrote: * Hi All Is there any particular thing that would stop excel from calculating. It was taking entries but formulas where not producing results and only previous results were being displayed. I have rebooted my spread sheet from a previous back up and all is now working . I am just a bit concerned it is something I did unknowingly Stew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Formulas not calculating when dragging down | Excel Discussion (Misc queries) | |||
Formula for shift schedule & calculating future dates - 2003 | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Whey is Excel 2003 calculating take so long - sometimes 20 minute | Excel Worksheet Functions | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions |