Pivot Table and External Data
 

Hi

I am using excel 2002. Our company has just converted to SAP and I am
attempting to set up Templates containing Pivot Tables. I created a Template
using SAP data, cleared the data while leaving the Headers, located the
cursor in cell A2 that contained the SAP data and saved the Template.

When I run SAP and tell it to populate the Pivot Table, it correctly opens
the Template but no data is transferred.

Looking at Excel, the External Data Toolbar is greyed out except for Refresh
All. I suspect I have missed a step in setting up the Template but don't know
what.

Thanks