corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel Help


New Topic

New Poll
  Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Excel Help
Brett
Premium Member

Avatar

Registered: 16th Dec 02
Location: Manchester
User status: Offline
   27th Feb 07 at 09:38   View Garage View User's Profile U2U Member Reply With Quote

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
27th Feb 07 at 09:58   View User's Profile U2U Member Reply With Quote

Go tools -> options -> calculation is calculation set to automatic?
Brett
Premium Member

Avatar

Registered: 16th Dec 02
Location: Manchester
User status: Offline
27th Feb 07 at 10:16   View Garage View User's Profile U2U Member Reply With Quote



A packet of these is on it's way

jaffa
Member

Registered: 27th Mar 00
Location: Stoke-on-Trent
User status: Offline
27th Feb 07 at 10:17   View User's Profile U2U Member Reply With Quote

Doug
Member

Registered: 8th Oct 03
User status: Offline
27th Feb 07 at 10:18   View User's Profile U2U Member Reply With Quote

I was just going to say about automatic calculations!

Got beaten too it.
Brett
Premium Member

Avatar

Registered: 16th Dec 02
Location: Manchester
User status: Offline
27th Feb 07 at 10:20   View Garage View User's Profile U2U Member Reply With Quote

Shut up, Doug. No you wasn't.
jaffa
Member

Registered: 27th Mar 00
Location: Stoke-on-Trent
User status: Offline
27th Feb 07 at 10:21   View User's Profile U2U Member Reply With Quote

quote:
Originally posted by Doug
I was just going to say about automatic calculations!

Got beaten too it.


too slow

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
Help needed again ...Trotty can you help Red_Corsa Geek Day 17 1679
21st Mar 03 at 00:15
by Red_Corsa
 
Any MS Excel experts Steve Geek Day 11 1300
4th Jun 04 at 14:19
by blebo
 
is there a program that...... chris_uk Geek Day 6 1904
16th Jun 05 at 00:47
by Dan B
 
Excel Help please !!! Mase Geek Day 2 757
16th Nov 05 at 11:27
by Mase
 
Excel help and making my life easier Melville Geek Day 9 977
26th Oct 06 at 14:17
by Melville
 

Corsa Sport » Message Board » Off Day » Geek Day » Excel Help 29 database queries in 0.0102060 seconds