Upgrade pivottable after running a macro failes

[torgn]

I`m trying to create a sheet where I can have pivot tables which can be updated with rawdata once a week. I have a column named Duration(seconds). I have made a macro that perform the following:
1. Creates a new column with header minutes
2. Convert seconds to minutes
So far, so good.
However, when I delete the raw data, And paste the new raw data and runs the macro and I try do update the pivot diagrams/tables, I receive an error message

I have one sheet for the raw data , and one sheet for the pivot table(s)

Something like this (translated from Norwegian)
Fieldname in pivot table is not valid. The data that is to be used to create a privot table report must be organized as a list with column labels. If you change name on a pivotfield, you have to give a new name to the field.

My questin is: What???

Second question is it possible to have an autoupdate of pivot tables?

[CK76]

My guess is that you have empty header row or some other table structure violation.

Upload a sample workbook where you encounter this error (along with your code), with sanitized data.

And it's definitely possible to auto-update pivottables via code.

[torgn]

Ok, I have a macro using this formula =convert(c3:"sec":"mn") and the macro also creates a new column to the right of c-column and adds a title Minute. In this example file I have not created a macro, but have manually created a new column, new header and added the formula. I haven`t tried to delete the rawdata sheet used for the pivot table and then copy and paste from the original rawdata in this book.

[CK76]

I'd need to see your code to effectively help you.

However, you can change pivottable source like below. Note that pivotcache source data range string must use R1C1 style reference.

Assuming PivotCache SourceData is originally set to Worksheets("Original Rawdata").Range("A1:D9")

Please Login or Register  to view this content.

[torgn]

"Problem" solved. I have still no Idea why it failed, but now it doesn`t. Thanks for all you help