Hi chocolate2346Originally Posted by chocolate2346
Try this, right click on the Pivot Table, click Wizard, a dialogue box will appear, click the Back button, a second dialogue box will appear that shows the source of the data
Hi chocolate2346Originally Posted by chocolate2346
Try this, right click on the Pivot Table, click Wizard, a dialogue box will appear, click the Back button, a second dialogue box will appear that shows the source of the data
Paul
No, I'm sorry but the suggestion does not give me what I'm looking for. For
example, the Pivot Tables that I'm currently working with are created from
queries in MS Access databases. When I click the back button as suggested,
below, I get the Get Data button. When I click the Get Data button, I get a
list of "Available Tables and Columns". I cannot see what the name of the
..mdb file is that the Tables and Columns/Fields are coming from. That window
also shows a list of "Columns in your query". However, it does not identify
the Table or Query that each column came from.
"Paul Sheppard" wrote:
> Try this, right click on the Pivot Table, click Wizard, a dialogue box
> will appear, click the Back button, a second dialogue box will appear
> that shows the source of the data
>
>
> --
> Paul Sheppard
>
>
> ------------------------------------------------------------------------
> Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
> View this thread: http://www.excelforum.com/showthread...hreadid=467550
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks