" REFERENCE IS NOT VALID "

  • Thread starter Thread starter EXPLORER
  • Start date Start date
E

EXPLORER

" REFERENCE IS NOT VALID "

THIS MASSAGE APPEAR WHEN I WANT UPDATE PIVOT TABLE USING REFRESH DATA KEY ,
SO DATA DOES,T REFRESH AND I DO NOT KNOW WHAT I CAN DO?
 
Hi there,

You could be getting that message because the pivot table is looking for
data that cant be found. Example : Data is not there at the location anymore
or ,the data has been deleted.
You must remember now that data stored in a pivot table is a direct link to
the feeding of data to that pivot table. So if the data is not there then, no
pivot table.

Hope this helps you
 
Back
Top