Brett
Premium Member
Registered: 16th Dec 02
Location: Manchester
User status: Offline
|
We use this spreadsheet at work, which has worked fine for the past 16month, but recently hasn't been functioning correctly.
It has formula in it that basically changes a word in the cell depending on dates that are input into another cell.
That aside, it used to update as and when you put the dates in. Now it doesn't update unless you press save 
|
jaffa
Member
Registered: 27th Mar 00
Location: Stoke-on-Trent
User status: Offline
|
Go tools -> options -> calculation is calculation set to automatic?
|
Brett
Premium Member
Registered: 16th Dec 02
Location: Manchester
User status: Offline
|
A packet of these is on it's way 
|
jaffa
Member
Registered: 27th Mar 00
Location: Stoke-on-Trent
User status: Offline
|
|
Doug
Member
Registered: 8th Oct 03
User status: Offline
|
I was just going to say about automatic calculations!
Got beaten too it.
|
Brett
Premium Member
Registered: 16th Dec 02
Location: Manchester
User status: Offline
|
Shut up, Doug. No you wasn't.
|
jaffa
Member
Registered: 27th Mar 00
Location: Stoke-on-Trent
User status: Offline
|
quote:
Originally posted by Doug
I was just going to say about automatic calculations!
Got beaten too it.
too slow  
|
Home
