Hi,

I have a client that is using an Excel spreadsheet to connect with a table
in an Access database. The db is 2003. We've tried an XLS file and an XLSX
file (both the same) but neither work. Essentially, somewhere along the line
the connection from the Excel file to the Access database got broken. Now
when we go through the dataconnections, to reconnect it, it won't take.
Everytime we refresh the pivot table, it clears out the pivot table. So,
it's not giving an error message that it can't find the Access table, it's
just clearing the pivot table, which makes we think that there's a field that
changed back on the table or something like that. But the fields are all the
same on the Access DB and the pivot tables. I realize that this question is
weird and hard to comment on. Anyways, any insight anyone has would be
great. Thanks again to all the MVP's!

-Alex