Microsoft Support

Microsoft Home Page

Sign in

Select the product you need help with

Select a solution

Refreshing Pivot Charts With a Macro
Hello Everyone, I have a workbook which I use MSQuery to import data from another workbook. From that data I create a pivot chart. I have code to refresh the data from the query and code to do what I
Creating a Pivot Chart on the Fly Via a Macro
Hello All, I'm trying to create a Pivtot Chart on the fly when I press a macro button. First I import (copy and paste) the data from another spreadsheet into a new sheet. Once I have that sheet
export access pivot table using vba and provide name and directory to store
Hi, I have created a query with a Pivot table and am trying to export to excel with a specific file name to a specific directory. I coded this to export the file without a specific name or location
Import pivot table data TO multiple worksheets
I need to create individual worksheets from my pivot table data in Excel 2010, how can this be done?
Issue due to import data to pivot table
During importing numberiс data becomes text in pivot tale, so I can not sum them, string of connection Provider=Microsoft.ACE.OLEDB.12.0;User ID=Admin;Data Source=C:\Documents and