ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Table - Error "Reference Is Not Valid" (https://www.excelbanter.com/excel-discussion-misc-queries/143591-pivot-table-error-reference-not-valid.html)

Olly

Pivot Table - Error "Reference Is Not Valid"
 
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.

--
Olly




All times are GMT +1. The time now is 03:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com