Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Refreshing Formulas

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I export data to Excel and then copy that data to another spreadsheet. Various formulas and graphs are referencing that data. When I put new data in, the formula cells and graphs don't refresh automatically. If I open a cell and save it refreshes. Anybody know of a way to get it to refresh automatically?

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    202
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    have you tried the excel help topic "Refresh external data"? i think this bit is what you are after:
    " You can refresh an external data range automatically when you open the workbook, and optionally save the workbook without saving the external data, so that the workbook file size is reduced. On the External Data toolbar, click Data Range Properties ,
    and then select the Refresh data on file open check box. To save the workbook with the query definition but without the external data, select the Remove external data from worksheet before saving check box."

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I just found it. Tools > Options > Calculation > Automatic

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Ho

    Use the button refresh external data thats ODBC links and will rip new good live data as a posed to odd bad data, live data is always best if poss before i get shot again, bad dat i class as out of date - but thats job specific, with me seconds count in finance world so always refresh and data hungry.


    I prefer to avoid auto updates as i like to command when i want data = so i refesh when i want, even calculation is manual so i havethe power to get as i want, worthy point the bigger the sheets more data and caculations the worst it gets.

    HTH


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •