Results 1 to 3 of 3

Thread: How Auto Refresh is possible in Excel

  1. #1
    Join Date
    Dec 2011
    Posts
    49

    How Auto Refresh is possible in Excel

    I'm sure it has been asked before and seems a pretty simple question, but can excel automatically refresh (calculate now, F9)? i.e. if i wanted to make a simple clock in excel by entering " =now() " into a cell, could I then make excel auto calculate this every second so that it keeps up with current time ?? So is it possible in excel to do this thing. If yes then how so if you guys have any of the information then please let me know

  2. #2
    Join Date
    Jun 2011
    Posts
    635

    Re: How Auto Refresh is possible in Excel

    Unless you use Tools|Options|Calculate to change things, Excel recalculates whenever a new formula is entered. With =NOW () in A1, type 5 in C1 and 7 in D1 and =C1+D1 in E1. Now wait a few minutes (make coffee) and change D1 to 20. When you hit the Enter key, nor only is E1 recalculated but so is E1 Alternatively use Format:Cell:Custom to format A1 as hh:mm:ss. Now you need wait only seconds

  3. #3
    Join Date
    Jul 2011
    Posts
    634

    Re: How Auto Refresh is possible in Excel

    You can try this but you have to Careful, this could tie up your system if you do it too long. So for this open a new work book, right click and view code paste this in the window

    Code:
    Sub Clock()
    
    'Create an iteration counter
    For i = 1 To Range("b1")
    
    'Recalculate the worksheet
    Worksheets("sheet1").Calculate
    'Update the worksheet with the latest iteration number
    Range("b2") = i
    
    'Increment value of i by i
    Next i
    
    End Sub

    In cell a1 =now() format to desired time view in cell b1 enter a number, 5000 would be a good start. Then go to tools-macro-select clock-run.

Similar Threads

  1. How to Auto refresh web page in firefox 4
    By NigmA DogE in forum Technology & Internet
    Replies: 5
    Last Post: 14-04-2011, 06:19 AM
  2. Windows 7 desktop does not auto-refresh
    By Noah in forum Operating Systems
    Replies: 7
    Last Post: 20-10-2010, 08:20 AM
  3. Delphi, TWebBrowser, Auto-Refresh???
    By alex198555 in forum Software Development
    Replies: 3
    Last Post: 22-07-2010, 10:41 AM
  4. Auto Refresh Iframe
    By cyber-noob in forum Software Development
    Replies: 3
    Last Post: 28-11-2009, 02:32 PM
  5. auto refresh Windows Explorer
    By Darpad in forum Windows XP Support
    Replies: 2
    Last Post: 04-02-2008, 07:46 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,643,208,049.33065 seconds with 17 queries