Pivot Table and External Data

C

Charles

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Pivot Table Data Aggregation 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
External Data Warning Message - I have No External Data in wrkbk 0
Can a pivot table be redirected to an external source? 1
Pivot table data source 1
Pivot Table Mapping 1
Retain pivot table formatting after refreshing data 0

Top