Pivot table - problem with sourcedata

**babymax** · 03-18-2016, 05:20 PM

Hi all,

I am new to macro's and this is my first one. I have trouble to get my pivot table to work in different sheets. In the syntax there is a hardcoded sourcedata which I think creates the error. Instead of this fixed name, it should be the name of the worksheet in which I want to execute the macro.

Anyone a line of advice? Underneath is the syntax, the line which I think is the troublemaker is in bold.

thx in advance.

Please Login or Register  to view this content.

**dOOb** · 03-20-2016, 10:59 AM

Hi,

I think you're right, the hardcoded sheet name might be the problem.

Try adding:

Please Login or Register  to view this content.

above the line which creates your PivotTable, and then, change it from:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and see if it works?

Pivot table - problem with sourcedata

LinkBack

Thread Tools

Rate This Thread

Display

Pivot table - problem with sourcedata

Re: Pivot table - problem with sourcedata

Thread Information

Users Browsing this Thread

Similar Threads

Pivot table problem - how to relate 3 sheets' data into 1 pivot table?

Can I use variables in the Sourcedata from a Dynamic Table??

VBA Pivot Table: Problem with pivot item visibility

How to update the sourcedata in existing pivot

Dynamic Pivot Table changing the SourceData

[SOLVED] Modify Pivot Table SourceData range

Pivot Table sourcedata string truncation

Bookmarks

Bookmarks

Posting Permissions