Question Locked

Excel 2003 Dropped Links

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have several places where I import data into Excel and use that data to create Pivot Tables.

Occasionally, when I open the Excel file and allow refresh of data, one of the tables does not get refreshed. When I check the linkage, there is none. It is as if the data is stand alone and I have to delete it and redo the import data function. After that it will continue to link and refresh until some future time when it may drop again.

3 replies

by thumbsup2

Can you give us some more information? Is it always the same table that does not refresh? Can you pin down any external factors that are always the same when this one table does not refresh? Example, are you logged in as the same user each time? Is this a shared spreadsheet located on a server?

Sorry, but pinpointing the cause of an event that happens "sometimes" or "occationally" is tough without more information. You are our eyes. What do YOU see?

by mzylberstein

The queries link to Microsoft Access 2003. It happens to more then 1 query. Actually it can be a table or a query. I have sole access to the spreadsheet. It just loses the fact that the cells are linked to a data import. I have tested it with the MDB open and closed. That does not seem to be the cause.

This discussion is closed to new replies.