I have since discovered that if any staff have an EFT of .23 it is not
displaying on the pivot table.

I have also discovered (I did not establish this pivot table but have
inherited it), that the formula that produces the EFT value is rounded, ie
the formula starts with =ROUND. It is rounded to two decimal places. If I
take the rounding off the formula, the result then appears in the pivot
table! But it appears with about 10 decimal places. Obviously that works as a
'workaround' because I can format the pivot table each time to only show two
decimal places. Problem is, this file is used by my 7 team members, and my
boss relies on it heavily and i don't really want her to have to reformat
each time she wants to view the refreshed pivot table.

Any other suggestions?