LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default Viewing source of a pivot table

I'm setting up a workbook with approximately six pivot tables per page. Each
pivot table is attached to a separate query in an external database. I've
just noticed, however, that all pivot tables on a page are pulling the same
data. What might be causing this? And how can I view the source of each
pivot table (the actual address of the queries, not the data produced by
drilling down) so I can verify that they're all attached correctly?
 
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
Changing Data Source for Pivot Table jjj Excel Discussion (Misc queries) 1 April 13th 06 09:36 AM
Need to Improve Code Copying/Pasting Between Workbooks David Excel Discussion (Misc queries) 1 January 6th 06 03:56 AM
Determine the location of an external source of pivot table? Pivot Novice Excel Worksheet Functions 3 June 1st 05 09:34 PM
Pivot table, dynamic data formula Excel GuRu Excel Discussion (Misc queries) 3 May 3rd 05 10:45 PM
Pivot Table Auto Update Data Source? Ket Excel Worksheet Functions 1 February 18th 05 11:14 PM


All times are GMT +1. The time now is 01:08 AM.

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

About Us

"It's about Microsoft Excel"