Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Displaying Source of an Excel 2K Pivot Table

Status
Not open for further replies.
CestusGW

CestusGW

Programmer
Jul 2, 2002
55
CA
Hi All

Is there any way to determine the source of the data in an Excel Pivot table? In my current scenario, I have a Pivot Table that has its worksheet source changed daily. How would I make a cell which would display which worksheet the data is coming from?

Thanx Greg W
wolgemga@aecl.ca
 
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
2K
remeng
remeng
Cpreston
  • Locked
  • Question
Pivot Table Issue
Replies
6
Views
495
Andrzejek
Andrzejek
Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
520
mintjulep
M
remeng
  • Locked
  • Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
405
remeng
remeng
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
885
bs6600
bs6600

Part and Inventory Search

Sponsor

Back
Top