"Reference is not Valid"

J

J Austin

I have an Excel 2007 table linked to an Access table and have created several
Pivot Tables from the Excel table. I am getting "Reference is not Valid"
error message during refresh. Is there any approach to finding the invalid
reference without having to tear apart and rebuid my many pivot tables. I'm
dealing with a table with approximately 2K rows and 20 columns. I pull
interim data tables (GETPIVOTDATA) for graphs which do not always have
complete data sets and give me a #Ref!, but I've had these previously and did
not get the error message.

Thanks in advance,

J Austin
 

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

Similar Threads

Reference is not valid for Pivot tables 2
Excel 2013 Pivot Data Range formula reference problem 0
Excel 2002 Pivot Table: Why reference is not valid ? 0
Excel 2007 pivot table using analysis services cube as data source 0
Pivot tabel field name not valid in 2007, was in 2003 0
Getpivot data dynamic reference 2
Pivot Table "Data source reference is not valid" error cause? 1
External reference is not valid ??? 12

Top