corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Geek Day » excel help formulas not updating automatically


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 formulas not updating automatically
Matt L
Member

Registered: 17th Apr 06
User status: Offline
20th Mar 09 at 10:54   View User's Profile U2U Member Reply With Quote

i have a alot of formulas that dont update when you change information unless you go to the cell and press f2 and enter quite annoyingtbh

any ideas on ho to fix it?

[Edited on 20-03-2009 by Matt L]
James_DT
Member

Registered: 9th Apr 04
Location: Cambridgeshire
User status: Offline
21st Mar 09 at 01:25   View User's Profile U2U Member Reply With Quote

Press F9 to manually update forumulae or:
Tools -> Options -> Calculation.
Change to Automatic.

[Edited on 21-03-2009 by James_DT]

 
New Topic

New Poll

  Related Threads Author Forum Replies Views Last Post
excel help Darren General Chat 3 901
28th Jan 05 at 15:04
by VegasPhil
 
is there a program that...... chris_uk Geek Day 6 1875
16th Jun 05 at 00:47
by Dan B
 
Excel help and making my life easier Melville Geek Day 9 954
26th Oct 06 at 14:17
by Melville
 
excel gurus paul.mitchell1984 Geek Day 2 382
13th Jun 07 at 12:52
by paul.mitchell1984
 
Working out 15% (VAT) in Excel. deano87 Geek Day 24 816
10th Feb 09 at 19:25
by deano87
 

Corsa Sport » Message Board » Off Day » Geek Day » excel help formulas not updating automatically 29 database queries in 0.0049849 seconds