• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Excel 2003 Pivot Table

I have an Excel 2003 Pivot Table.  
my question is this:

How can I determine the source data of this pivot table?  It may be sql sever or a data set on the sheet but I can not see where there is a definitive data source for this pivot table.

0
michaelrobertfrench
Asked:
michaelrobertfrench
  • 2
1 Solution
 
syeager305Commented:
click on the pivot table, the click on the options tab, click change source, it should show you . :)
0
 
syeager305Commented:
I guess I could be more specific, click on the pivot table, then you'll see that the options tab appears, click on it, the on the options tab - click change source, there it will show you database source.

0
 
michaelrobertfrenchAuthor Commented:
thank you
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now