Pivot table weirdness

[Sir Tokyo Sexwale]

I have a pivot table that's not updating for new data - or at least not all of it. I know you're thinking the new data is outside the range but it isn't. Here's an example - 

 

Range (Date Source) is set as $A$2:$J$112

 

I'm only using as far as line 92 right now, so I have a cushion at the bottom.

 

The data table has clients - say A - D

 

I add 5 new jobs, 3 to existing clients & 2 new clients, E & F

 

I refresh the pivot & it's different by the sum of E & F, and they're within the range. To test this, I change the client names to one or 2 of those pre-existing ones (A-D) - now the pivot table agrees when refreshed. Change the client names back to what they should be, refresh & it's out again. 

 

f***ing weird. The only fix I can find is to make a new pivot table

[Jonesy]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[John am Rhein]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Nebraska Red]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[New York Red]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here

[Senrab_nhoj]

This post is not viewable to guests.

You can sign in to your account at the login page here

If you do not have an account then you can register here