Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot Table - Reference is not valid Sinner Excel Worksheet Functions 1 March 31st 07 06:57 PM
Pivot table - Reference is not valid Sinner Excel Discussion (Misc queries) 1 March 31st 07 06:47 PM
Pivot Table - Reference is not valid Sinner Links and Linking in Excel 0 March 31st 07 04:18 PM
Deleted the pivot table - continue to get the "overlap" error message [email protected] Excel Discussion (Misc queries) 0 September 27th 06 04:07 PM
"File Format Not Valid" When Starting Excel. Error Code 0D3F6000 EMT_Hawk Excel Discussion (Misc queries) 4 March 31st 06 09:22 PM


All times are GMT +1. The time now is 01:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"