Does anyone know of a way to force excel to reread the iqy file? I am trying to find a way to have a formatted excel spreadsheet that uses the iqy file for it's data input. The problem is, that once I have imported the data, even though the iqy file may change, excel still processes the query using the iqy settings at the time it was imported.
I am trying to automate this process so that the first thing it does is reload the iqy file and data.
TIA
I am trying to automate this process so that the first thing it does is reload the iqy file and data.
TIA