|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Rate Thread | Display Modes |
11-21-2005, 11:17 PM
|
#1 |
|
Member (8 bit)
Join Date: Jan 2002
Location: Santa Maria, Ca
Posts: 171
 |
Excell problem
Hey Im working on an office right now where their Excell worksheets will not calculate untill the sheet is saved. So when you fill in a key none of the keys that have formulas that work off what you filled in will calculate immediatly like they used to. So you go and save your work and the will calculate just before it saves. It happens on all 4 computers on the network. I ran a repair on each computers office program, and i update all with latest microsoft updates for office xp. Nothing fixed the problem, I hope Ive made sence, anyone have an idea of what i can do?
|
|
|
|
11-22-2005, 01:52 AM
|
#2 |
|
Barefoot on the Moon!
Staff
Premium Member
Join Date: Aug 2002
Location: Northeastern USA
Posts: 13,384
|
Formula calculations are instantaneous unless there's something wrong with the forumula. You may want to double check them.
__________________
There are two secrets to staying young, being happy, and achieving success. You have to laugh and find humor every day, and you have to have a dream.
|
|
|
|
|
11-22-2005, 06:19 AM
|
#3 |
|
Ride 'em Cowboy
Join Date: Dec 1999
Location: Dallas, Tx
Posts: 9,109
|
F5 is the manual key to recalc.
Look in Tools->Options->Calculations and is if auto calc is turned off.
__________________
Stand Up 2 Cancer - SU2C |
|
|
|
|
11-22-2005, 12:28 PM
|
#4 |
|
Member (8 bit)
Join Date: Jan 2002
Location: Santa Maria, Ca
Posts: 171
|
That was it. I switched to automatic and all is great.
Thanks! |
|
|
|
|
| Bookmarks |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
Linear Mode
