• Pivot Table Templates

    By Robert Sloan 1 decade ago

    Hello, I love this tool. I have begun testing 2.4 and does everything promised. I do have a question on the use of MS-Excel templates. I have a template with embedded pivot tables. I get the data to load into the spreadsheet properly but it does not update the pivot tables after it completes. Is there anything that I may be doing with the format of the template which could cause this to happen. Any advice you could provide would be great. Do you have a sample template that I could use as a guide perhaps?

    • There is a demo profile in 2.4

      By Johnny Jiang 1 decade ago

      Hi Robert,

       
      There is a demo profile in the database called Demo Case 03 - Excel Templates, you can run it and should be able to see the pivot table and chart get updated and refreshed. 
       
      If you open the Excel template attached, you could see some VBA code in there, we use those code to refresh pivot table and charts when switching worksheets. You could build your own Excel templates based on our template.
       
A VBA sample of refreshing pivot tables 
—————————————————–
Private Sub Refresh_Pivot()
    ActiveSheet.Range("A1").Select
    
    varCellRef = Sheets("Data").UsedRange 'Calculate dimension of used range