Pivot Table missing lines

[Slewrate]

Hi Folks! I have a pivot table derived for a worksheet of about 250
lines. When I add additional rows to the work sheet, sort it, and sav
it followed by refreshing my pivot table, I'm missing the last two item
in this pivot table. I can repeat this every time. When I creat
another identical pivot table for the same updated worksheet, my las
to items are in this new pivot table. Always the last two items!

Any suggestions. I thank you in advance for your feedback.
Best Regards, Slewrat

 

[Ken Wright]

Right click on the table, hit wizard, and then back - Now check that the range
you have selected actually includes those two last rows.

 

[Debra Dalgleish]

You could use a dynamic range as the pivot table source, and it will
adjust automatically as the number of rows on the worksheet changes.
There are instructions here:

http://www.contextures.com/xlPivot01.html

 

[Slewrate]

That's it! Now I just have to practice my spelling. So, tanq u ver
mush fur dat anzwer.

Best Regards
Slewrat