Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2004
    Posts
    2

    Unanswered: excel external data refreshing

    hi,

    i have an excel spreadhseet that imports data from an external database. the spreadsheet is set to refresh every minute and on opening. i have another spreadsheet that "VLOOKUP"s information from the first spreadsheet. the first spreadsheet does not refresh itself when it is close. is there any way i could set the 1st spreadsheet to update itself when it is closed.

    any help will be much appreciated

  2. #2
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188
    Simply write a macro to refresh the list and put it in Workbook_BeforeClose event
    qha_vn

  3. #3
    Join Date
    Feb 2004
    Posts
    2
    Yes but the workbook is closed. it won't be opened but needs to be refreshed every 2 minutes. Any ideas?

    Originally posted by qha_vn
    Simply write a macro to refresh the list and put it in Workbook_BeforeClose event

  4. #4
    Join Date
    Jan 2003
    Location
    Vietnam
    Posts
    188
    Originally posted by excelenz
    Yes but the workbook is closed. it won't be opened but needs to be refreshed every 2 minutes. Any ideas?
    oh sorry, i misunderstood. there are 2 suggestions for u

    - write a macro in the 'lookup' file to open the data file every 2 minutes (it needs to be open all the time, doesnt it?
    - or combine 2 files into one.

    hope this helps
    qha_vn

Posting Permissions

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