RUN TIME ERROR 1004--The PivotTable field name is not valid.

G

Guest

Hi All experts,

I urgently need help to resolve this problem.

The macro to create the pivot table had worked fine until a change of the
hard coded location of the data source - just file path changes.

When run the macro again, I got a error message:

Run-time error "1004"

The PivotTable field name is not valid. To create a PivotTable, you
must use data that is organized as a list with labeled columns. If
you are changing the name of a PivotTable field, you must type a new
name for the field.


If I click Debug, I got another error message:

Out of memory.

I have to click OK on the message box 3 times to get the debug mode.

The code is as the follows:

Selection.CurrentRegion.Select
Selection.Name = "GO"

ActiveWorkbook.PivotCaches.Add(SourceType:=xlDatabase, SourceData:= _
"GO").CreatePivotTable TableDestination:="" _
, TableName:="PivotTable4"

Any ideas and suggestions will be very much appreciated.

Linda
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

"Run-Time Error '1004' 2
Pivot table in VB 3
pivottable name in a macro 2
Creating PivotTable in Macro 2
Pivot Table Macro with dynamic source data 1
Variable Address in Pivot Table VBA code 4
Pivottable code problem 4
The PivotTable field name is not valid (error) 1

Top