Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bebot Chan
  Where is Bebot Chan?
 Saudi Arabia
 Bebot Chan
 To: Kiran Kumar Singh
  Where is Kiran Kumar Singh?
 New Delhi
 Kiran Kumar Singh
Subject: RE: Refreshing Pivot Table using VFP
Thread ID: 50880 Message ID: 51027 # Views: 1 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Wednesday, September 08, 2004 8:13:06 AM         

> Hi,
> How do i refresh a pivot table by using visual foxpro. may be there are some sets of code to do the same.
> opening a excel file, refresing the privot table and closing the excel file
> I have gone throught the Dynamic Data Exchange (DDE) functions. but could get the information how to use those functions, if those are related to the above topic.
> Please help
> Kiran

What about doing it from Excel? In the Table Options of the pivot table, unselect "Save data with table layout" and then select "Refresh on open". That will automatically refresh the pivot table when user opens the file similar to what you want to achieve.


Refreshing Pivot Table using VFP Posted by Kiran Kumar Singh @ 9/6/2004 8:55:54 PM
RE: Refreshing Pivot Table using VFP Posted by Ken Blum @ 9/7/2004 4:15:01 PM
RE: Refreshing Pivot Table using VFP Posted by Bebot Chan @ 9/8/2004 8:13:06 AM