PivotTable Error

[Ark68]

I have made a Pivot Table on worksheet "CRITERIA"
As part of my code, I call to refresh that Pivot Table because it's contents are based on a dynamic dataset.
I am getting an error : "The PivotTable field name is not valid. ..." with line

 Sheets("CRITERIA").PivotTables("PivotTable1").PivotCache.Refresh

The dataset does have a valid column header for which the PivotTable uses to base it's count. Could it have something to do with the dataset having been "re-drawn" in a previous sub (importing the data from an external sopurce)?

How can I eliminate this error and have my PivotTable update it's values?

Jenn

 

[Ark68]

Found the error. One of the first cells of the range of columns I was using was empty. You're not supposed to have a blank first row cell apparently.

 

[Ark68]

OK ... new problem.
Why does my PivotTable contents disappear after I run my subrountine that imports data to be analysed by this PivotTable?

I have my PivotTable initially set up manually, and though that a simple refresh command would be all that was needed to compensate for the new data input.

Jenn

 

[james_lankford]

when you import the data, is it on a sheet with the same name that the old data was on ?
are the number and name of columns the same ?

 

[Ark68]

Thank you James for your reply ....

The worksheet name and column headings remain unchanged. During the import of new data. Part of the import process involves deleting the header row and replacing it in case this may be the culprit.

When I go back to the PivotTable and try to use the Wizard, my original data range has changed from the original column (of a one column data reference) and thus I am unable to make the same field query. (ie the query is supposed to be based on column D "Type", but after I run my sub, it is trying to use column F "Function", which is not what I want)

Jenn

 

[Greg Truby]

Part of the import process involves deleting the header row and replacing it in case this may be the culprit.

Yes, this is bad voodoo. Will reset the pivot.

 

[Ark68]

OK, thanks Greg.
I suppose I'll have to revist my sub importing the data as to not delete the header row in the process.