Hey all,
I have imported some MS Access queries to an excel spreadsheet so I could have all of the data in one place and also to do some manipulation. The problem I am seeing is that the link to the external query seems to get lost randomly after an update. When you right click on the data you get a "Refresh Data" option, but sometimes it goes away after a refresh and I have to reinsert the query. Anybody else seen this and figured out a fix? btw, I am running Excel 2003 SP3. Any tips greatly appreciated.
I have imported some MS Access queries to an excel spreadsheet so I could have all of the data in one place and also to do some manipulation. The problem I am seeing is that the link to the external query seems to get lost randomly after an update. When you right click on the data you get a "Refresh Data" option, but sometimes it goes away after a refresh and I have to reinsert the query. Anybody else seen this and figured out a fix? btw, I am running Excel 2003 SP3. Any tips greatly appreciated.