excel external data refreshing

excelenz · #1 (**permalink**) 02-26-04, 14:57

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

qha_vn · #2 (**permalink**) 03-04-04, 03:49

Simply write a macro to refresh the list and put it in Workbook_BeforeClose event

excelenz · #3 (**permalink**) 03-04-04, 15:15

Yes but the workbook is closed. it won't be opened but needs to be refreshed every 2 minutes. Any ideas?

Quote:

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

qha_vn · #4 (**permalink**) 03-04-04, 21:29

Quote:

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

Internet Services

Web Development

Digital Marketing

Consumer Tech