Hi,
I keep having problems with a pivot table that I created. The data and the
query is in access. I refresh the pivot table daily and then print it out.
About 5-6 times now the file with the pivot table won't open. The Excel
error message is "Unable to open file". I have to delete it and recreate it
each time. It will then run fine for a while but then I can't open the file
again. I have several other excel files with pivot tables where the data and
queries are in Access and do not have trouble with them. I have also run the
query in access and it looks fine. It returns the usual results. Can
someone tell me why this keeps getting corrupted?

Thanks,
--
Chuck W