Pivot Table Still Dropping Data

[Guest]

Each time I input information into my spreadsheet and refresh my Pivot Table
data it keeps dropping my bottom portion of my spreadsheet. I have sibmitted
a question for help before but the responses didn't fix my problem. Can
someone please HELP!

 

[Dave Peterson]

Any chance your pivottable range needs to be readjusted.

You can rightclick on the pivottable and choose Wizard and step backward to get
to the step that asks what range to use (if you want to do it manually).

Or maybe you could use a name that will react to row insertion/deletion.

Debra Dalgleish has some notes for dynamic range names:
http://contextures.com/xlNames01.html#Dynamic