MS Excel - Way to auto update values without closing and re-opening workbook?
Posted on 2011-02-17
I have an Excel 2007 workbook (XLS format) that uses VLOOKUP to populate data from another workbook on our network. It works great, but the workbook from which it grabs data from is always changing. So I always need to have the most up to date data. Currently, I have to click Data>Edit Links>Update Values or close and re-open the workbook.
Is there a macro or something to tell Excel to automatically do an Update Values every X minutes?