" REFERENCE IS NOT VALID "

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?
 
G

Garreth Lombard

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top