I have 2 workbooks in the same folder (My Documents).

1 has several worksheets with raw data (Row 1 = headings, then data)

1 has several worksheets with pivot tables and pivot charts that are based
on the data in the first worksheet.

Every time I open the workbook containing the pivot tables and charts, the
path to the data sources for each pivot chart and table has changed from My
Documents to: C:\Documents and Settings\username\Application
Data\Microsoft\Excel

Even if I edit the data source for each chart/table, and then save the
workbook, when I open it again, the paths to the data sources reverts to:
"C:\Documents and Settings\username\Application Data\Microsoft\Excel"

Is anyone else out there having the same problem?