<div>
Probably not what you want to hear, but I believe you'll have to rebuild the pivot table from scratch if you want to eliminate the ghost of accounts past. <br />
<br />
Thomas
</div>


Probably not what you want to hear, but I believe you'll have to rebuild the pivot table from scratch if you want to eliminate the ghost of accounts past.

Thomas

<div>
Hi, BigWill5112.<br />
<br />
It depends on the version of Excel you're using. In Excel 2010 (IIRC, it's similar in 2007)...<br />
<br />
In the &quot;PivotTable Options&quot; dialogue, click on the &quot;Data&quot; tab. Change &quot;No. of items to retain per field&quot; to &quot;None&quot;.<br />
<br />
What version have you got?<br />
<br />
Regards,<br />
Brian.
</div>


Hi, BigWill5112.

It depends on the version of Excel you're using. In Excel 2010 (IIRC, it's similar in 2007)...

In the "PivotTable Options" dialogue, click on the "Data" tab. Change "No. of items to retain per field" to "None".

What version have you got?

Regards,
Brian.

<div>
BigWill5112,<br />
<br />
Please see <a href="http://www.contextures.com/xlpivot04.html" rel="ugc">here</a> for pre-2007.<br />
<br />
Regards,<br />
Brian.
</div>


BigWill5112,

Please see here [http://www.contextures.com/xlpivot04.html] for pre-2007.

Regards,
Brian.

<div>
<div class="content wysiwyg-content">
workig with some financial data. &nbsp;the data that the pivot table pulled from originally contained account 184. &nbsp;My new data set does not contain 184 but on the pivot table in the account field it still allows you to select 184 but you get no data. &nbsp;I have refreshed that data and made sure I do't have other filters on. &nbsp;anyhelp?
</div>
</div>


workig with some financial data.  the data that the pivot table pulled from originally contained account 184.  My new data set does not contain 184 but on the pivot table in the account field it still allows you to select 184 but you get no data.  I have refreshed that data and made sure I do't have other filters on.  anyhelp?

Pivot Table field has values that don't exist

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