Doesn't it always happen! You post and then suddenly the answer emerges!

The Pivot Chart in the copy was still linked to the Pivot Cache in the
original workbook. Even though the External Links was blank, the link
remained. I deleted the chart and recreated and the Analyze Tab came back.

Every day's a school day eh?

"Bony Pony" wrote:

Hi all,
Perplexing this!

I have two workbooks containing the same Pivot chart. One workbook (the
original) shows the Analyze Tab in Chart tools and the other (a copy) doesn't.

There are no external links to the original from the copy and the data
source and the underlying Pivot Table work fine.

Any ideas?

Thanks!

Bony