NigelTufnel
Board Regular
- Joined
- Apr 3, 2008
- Messages
- 53
- Office Version
- 365
- Platform
- Windows
Is there a way to identify a Pivot Table's data source quickly with one-click or hover-over without using "Change Data Source".
This may sound silly to some people, but I've always disliked having to go to "Change Data Source" to do this. It's not the easiest-to-read (highlighted text in the middle of a dialog box), and it's an input field, so there always the possibility of an accidentally overwrite. I just want some read-only information.
I realize it would be easy to create a macro to do what I want and report that information in a message box, but is there some functionality already in Excel that will do this for me, i.e., report the data source(s) for the active Pivot Table in a read-only manner?
(Am I the only one who thinks getting information by going to a command to change that information is silly?)
This may sound silly to some people, but I've always disliked having to go to "Change Data Source" to do this. It's not the easiest-to-read (highlighted text in the middle of a dialog box), and it's an input field, so there always the possibility of an accidentally overwrite. I just want some read-only information.
I realize it would be easy to create a macro to do what I want and report that information in a message box, but is there some functionality already in Excel that will do this for me, i.e., report the data source(s) for the active Pivot Table in a read-only manner?
(Am I the only one who thinks getting information by going to a command to change that information is silly?)