How can I automatically update spreadsheet cells every two minutes?

pankaj May 24, 2013
Pinterest Stumbleupon Whatsapp
Ads by Google

I have a spreadsheet. I update Cell B1,B2 and B3 every two minutes automatically based off share prices.

Now I want cell C4 to update the data of the previous cells as well every two minutes.

How can I automate this?

 

  1. pankaj
    May 25, 2013 at 9:17 am

    Dear,

    Thank you for the reply.

    i have share price feeds of different markets imported by excel from the web(web query source yahoo finance).

    Like in B1 ,Aaple share price is cauto fed, B2 Eur Usd is auto fed after every 2 minutes automatically and so on,

    what i want is ,In cell C4 i want the price of B1 and B2 to be updated every 2 minutes automatically.

    With best regards,
    Pankaj

  2. ha14
    May 25, 2013 at 9:06 am

    manually you can do it i think if you press F9?

    Excel 2003: Tools-Options-Calculation-Automatic.

    Excel 2007: Office button-Excel options-Formulas-Workbook Calculation-Automatic.

    Excel 2010: File-Options-Formulas-Workbook Calculation-Automatic.

  3. Bruce Epper
    May 25, 2013 at 12:42 am

    Just turn on autocalculate (if it is off) for the sheet. Any time any value in any cell changes, it will automatically update all other cells on the sheet.

    • Rajaa Chowdhury
      May 25, 2013 at 1:20 am

      Bingo!!! Absolutely the correct answer and a simple task for MS Excel.