|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
07-17-2005, 07:00 AM
|
#1 |
|
Member (8 bit)
Join Date: Apr 2001
Location: Shropshire; UK
Posts: 136
|
Problem with Excel not responding
One of my workbooks in Excel has suddenly stopped responding (calculating)to inputs, and I am stumped as to why. When applying changes etc. that would normally be updated, the changed number say can be input, but there is no change as there should be in the resultant formula.
It is only happening on this particular workbook and others on my pc are ok and responding as norm. Can anyone suggest what has caused this please?
__________________
Basil |
|
|
|
07-17-2005, 09:32 AM
|
#2 |
|
Ride 'em Cowboy
Join Date: Dec 1999
Location: Dallas, Tx
Posts: 9,109
|
Open the workbook and click Tools->Options->Calculations tab. Make sure MANUAL isn't checked.
Back in the old days when spead sheets were large and pc's were small, the maual open was a nice thing. Pressing F5 forced a manual calculation.
__________________
Stand Up 2 Cancer - SU2C |
|
|
|
|
07-17-2005, 10:49 AM
|
#3 |
|
Member (8 bit)
Join Date: Apr 2001
Location: Shropshire; UK
Posts: 136
|
Thanks EzyStvy, that's done the trick. Don't know how that happened though.
|
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
