It sounds like you are overloading Excel. You are specifying entire columns
A to Q, which is over 17 million cells. Try just specifying the cells with
data.

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

"funnybroad" wrote in message
...
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?