XL2007 Pivot Charts: Path to data in another workbook keeps chang

[Guest]

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?

 

[Guest]

Additional information:

Every time I do this, it causes Excel to crash and restart:

1) I edit the data source path for a pivot chart, and change it to:
'C:\Documents and Settings\username\My
Documents\[WeeklyStatusReport_data.xlsx]UserDetails'!$A:$Q

2) I right-click on the pivot chart and do a "Refresh"

It causes Excel to bomb and restart.

 

[Guest]

Even more information:

If I copy my workbook containing the data to "C:\Documents and
Settings\username\Application Data\Microsoft\Excel", and I do a "refresh" on
any of the charts, it also causes Excel to bomb and restart.

 

[Bob Flanagan]

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