Update data from Excel pivot table.

[Guest]

Hi

I have created some pivot tables in excel that I want to show in an
powerpoint presentation. The pivot table updates every 10 minutes in Excel
but not in Powerpoint. How can I get it to do so?


Brgds /Errit

 

[Steve Rindsberg]

Hi

I have created some pivot tables in excel that I want to show in an
powerpoint presentation. The pivot table updates every 10 minutes in Excel
but not in Powerpoint. How can I get it to do so?

PowerPoint normally only updates links to external data when the presentation
is opened or when the user manually updates links.

Have a look here for a possible solution:
http://www.presentationpoint.com/

I think you may also find some example vba code on http://skp.mvps.org

 

[Guest]

Hi Steve

Thanks for swift reply.
I have testet the tool you mention, but I have had no luck. I believe its
because that Im running Office 2007 or beause the data I want to update is a
Pivot table?

Any other help would be appriciated.

 

[Steve Rindsberg]

Hi Steve

Thanks for swift reply.
I have testet the tool you mention, but I have had no luck. I believe its
because that Im running Office 2007 or beause the data I want to update is a
Pivot table?

Any other help would be appriciated.

I'd write the developer of the tool.

Other than that, you may have to write your own using some of the code examples at
skp.mvps.org