<div>
The SourceData for a pivot table must be one contiguous range.
</div>


The SourceData for a pivot table must be one contiguous range.

<div>
then how to do it if one wants to have filtered data show in a pivot without having to everytime redesign the pivot.<br />
gowflow
</div>


then how to do it if one wants to have filtered data show in a pivot without having to everytime redesign the pivot.
gowflow

<div>
You have to filter the pivot the same way as the source, or copy the filtered data to another area and use that as the source data. The former is easier. ;)
</div>


You have to filter the pivot the same way as the source, or copy the filtered data to another area and use that as the source data. The former is easier. ;)

<div>
ok suppose I copy and I have a contiguous range suppose it is<br />
Sheet1!$A$3:$C$9<br />
<br />
How do I programmatically now affect this new range to the existing pivot<br />
gowflow
</div>


ok suppose I copy and I have a contiguous range suppose it is
Sheet1!$A$3:$C$9

How do I programmatically now affect this new range to the existing pivot
gowflow

<div>
Great help as usual.<br />
Tks v much<br />
gowflow
</div>


<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
I know that you can change the SQL querry for a Pivot in something like<br />
Activesheet.pivottables(1)<wbr />.pivotcach<wbr />e.commandt<wbr />ext = &quot;SELECT * FROM ....<br />
<br />
What is the command to change the Data Range<br />
like my pivot give me this value Sheet1!R1C1:R11C3 for SourceData<br />
Activesheet.pivottables(1)<wbr />.SourceDat<wbr />a = Sheet1!R1C1:R11C3<br />
<br />
how can I get it to point by VBA to a different range say Sheet1!$A$1:$C$1,Sheet1!$A<wbr />$3:$C$9<br />
<br />
Tks<br />
gowflow
</div>
</div>


Hi

I know that you can change the SQL querry for a Pivot in something like
Activesheet.pivottables(1).pivotcache.commandtext = "SELECT * FROM ....

What is the command to change the Data Range
like my pivot give me this value Sheet1!R1C1:R11C3 for SourceData
Activesheet.pivottables(1).SourceData = Sheet1!R1C1:R11C3

how can I get it to point by VBA to a different range say Sheet1!$A$1:$C$1,Sheet1!$A$3:$C$9

Tks
gowflow

Pivot Table Change Data Range thru VBA

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.