Microsoft Support

Microsoft Home Page

Sign in

Select the product you need help with

Select a solution

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
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
How can I import a CSV file into an excel table or Pivot Table?
How can I import different CSV files which have the same structure into an excel table or pivot table? I want to be able to have my data sorted, calculated automaticaly as I change the source
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?