Hi all,


As I read on another thread, I tried to use the conditional formatting in order to eliminate #REF error (due to lack of a certain item in pivot, that I'm going to reference with GETPIVOTDATA) but I still have the #REF as the result of sum several items if one of it is #REF.
Is there any solution to solve this issue?

Thanks in advance,
regards,

Pat