Excel Pivot Chart problem

[StopSign]

I am by no means an expert with Excel, so bear with me here.

I am working with this "program" which is basically a series of spreadsheets linked together with VBA macros. On one of the spreadsheets, there is a worksheet containing a summary of data. It contains no links. There is another worksheet with a pivot table on it that reads off the first worksheet. The spreadsheet file works fine as of now.

The problem is that when I make a pivot chart using the pivot table, it somehow creates to a link to one of the other Excel files. I don't know where the link is because all I know is that when I open this file (with the pivot chart), it asks me to locate the "OtherFile.xls" Manually locating it doesn't help because the next time I open it, it asks for it again. What's even weirder is that a bunch of the other spreadsheets in this "program" also contain the exact same pivot chart but don't have this link problem.

I'm not very adept with Excel and all I know is that the pivot chart reads off of the pivot table. Presumably, whatever link there is should be from the pivot table, right? However, if I just delete the pivot chart, the problem is gone. If I delete everything *on* the pivot chart to only leave a blank worksheet that used to contain the pivot chart, the problem is still there. The pivot chart's worksheet simply being there causes the problem. It makes no sense to me.

 

[mayest]

I don't use Pivot Tables or Pivot charts, but you might try a couple of things to locate the link:

1) Go to Insert --> Name --> Define and see if there are any names in there. If so, check to see if they link to another worksheet. Excel sometimes creates names for things like the print area, so maybe it does for Pivot Charts.

2) Try this FindLink

3) I assume that you know this, but look in Edit --> Links to see if anything is mentioned there.

 

[StopSign]

Thanks a lot! #3 solved the problem.