Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble recreating Pivot table changes in VBA
Im having some problems with my pivot table changes in VBA
I am calling my pivot table up like below but when I add the sourcetyp and sourcedata, it gives me the following error: Run Time Error '1004'; The Pivot table field name is not valid. To create a pivot tabl report, you must use data that is organised as a list with labelle columns. If you are changing the name of a pivot table field , you mus type a new name for the field Here is my code: [vb] Sheets("source Code").Activate ActiveSheet.PivotTableWizard SourceType:=xlDataBase SourceData:="'!Quotes 2004' !$a$1:$k$6336" ActiveWorkBook.ShowPivotTableFieldList = True [/vb] Anyone shed any light on this -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trouble recreating Pivot table changes in VBA
It is much easier to record a macro when making up a pivot table an
amend that as necessary -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Office 2007 and Pivot Table Trouble | Excel Discussion (Misc queries) | |||
Recreating the DateSerial()/Date() function | Excel Worksheet Functions | |||
RECREATING THE PROBLEM !!!!!!! | Excel Discussion (Misc queries) | |||
I am having trouble keeping numbers formatted in a Pivot Table | Excel Discussion (Misc queries) | |||
How do I change my DSN without recreating the odbc connection? | Excel Worksheet Functions |