Capturar.JPG

<div>
Or, select a cell in the pivot table, then click the Options ribbon in the Pivot Table Tools and click Change Data Source.<br />
<br />
cheers, 
</div>


Or, select a cell in the pivot table, then click the Options ribbon in the Pivot Table Tools and click Change Data Source.

cheers,

<div>
You are extra fast, thanks very much found like this
</div>


You are extra fast, thanks very much found like this

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
Can you please advise I assume in a simply question, in Excel 2010 I can not find how to check the source data of a created pivot.<br />
<br />
In Excel 2000 this was right click on the table, after selecting Table Wizard, clicking Back and there were that for example from A2:G16.<br />
<br />
thanks,
</div>
</div>


Dear Experts,

Can you please advise I assume in a simply question, in Excel 2010 I can not find how to check the source data of a created pivot.

In Excel 2000 this was right click on the table, after selecting Table Wizard, clicking Back and there were that for example from A2:G16.

thanks,

Excel 2010 - Pivot data source

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