Debra Thanks for your help and interest. Will read the article - thanks again.
--
Sharon


"Debra Dalgleish" wrote:

I haven't encountered a similar problem. Although it's targeted to Excel
2002, perhaps the suggestions in the following article will help:

XL2002: Pivot Table Fields Do Not Function After Excel Repairs and
Recovers File
http://support.microsoft.com/kb/322238/

Sharon wrote:
Hi Debra

The source is a query in an Access Database. I have checked the data in the
query and all of the items are there with data. If I recreate the table it
will work for a while but I think it may have something to do with the
AutoRecover?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html