Pivot Table Issue

[dendevils]

When I refresh the pivot table I am working on, the column headings remain, but all the data disappears. I checked the data source and it is correct.
What am I doing wrong? How do I get the data to properly move to the pivot table?
Thank you

 

[Oeldere]

there are more pivot tables in your sheet?

I read yesterday, that a cache of the data is been held in the file, which coases trouble (sometimes).

 

[dendevils]

This is the only pivot table in the worksheet.

 

[RoryA]

Did you change the data?

 

[dendevils]

ADVERTISEMENT

Yes. I have done this before in other worksheets, but never had this issue.

 

[RoryA]

How exactly did you change the data?

 

[dendevils]

ADVERTISEMENT

I changed some of the $ amounts and added new rows for additional data (it is a budget schedule).

 

[RoryA]

Where did you add the new rows - to the end, or by inserting them at the beginning?

Is the pivot table set up to use a fixed range, a Table or a dynamic range for its data?

 

[dendevils]

The rows were added to the bottom of the existing table and it is a fixed range.

 

[RoryA]

But if it's a fixed range, adding them to the bottom of the table wouldn't add them to the pivot source.