Hi,

I have never tried linking the Access PT to an Excel PT, but generally I
would build a pivot table in Excel which is connected to the Access table or
query. Then you get all of Excel's pivot options but are able to directly
refresh the Access data.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Faboboren" wrote:

Hi,
I have a database in Access, and then I have created a Pivot Table in
Access......

In Access I can get original numbers under Sum of Linear (I am adding before
numbers to get to this point) or with function show as percent of parent row
item percentages within the Banner...

But then I want to publish that in Excel, and I am getting back my original
numbers instead of percentages.. Any way to keep percentages in Excel pivot
table and keep link to Access Pivot Table..
Thanks