Pivot Table - Error "Reference Is Not Valid"

O

Olly

I have created a pivot table which uses an external data source (oracle
database, through OLEDB)

The data is retreieved perfectly, the pivot table works fine, but whenever
data is refreshed (or if the query is edited), I receive the error message
"Reference is not valid"

I don't understand why this error is being shown, or how to get rid of it.
Anyone?

Excel 2007 on Windows XP, querying Oracle 9i db.
 

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

Pivot Table Counting Text Data 0
Pivot Table "Data source reference is not valid" error cause? 1
Excel 2013 Pivot Data Range formula reference problem 0
The PivotTable field name is not valid (error) 1
Referencing a pivot tables Grand Totals Column 1
Excel 2002 Pivot Table: Why reference is not valid ? 0
"Reference is not Valid" 0
Reference is not valid for Pivot tables 2

Top