Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Windows XP
Excel 2002 SP 3 I have a worksheet that is populated with external data from MS Access. I return the data as a querytable, and then create some pt's (pivot tables) off these querytables. Some of my page fields in the pt are little more than unique identifiers. They only serve to tell me whether or not my query and pt have refreshed properly after my refresh code runs (its bee known to act up from time to time). These page field identifiers only hold one piece of data, yet they change every time I refresh my querytable. As such I leave them as "all" within the page field drop-down on the pt, because if I actually selected a value, the next time I refreshed, it would no longer be a choice. I would like to see the values of the drop down (not necessarily select it) without having to click on the drop down. Is there a formula or something i could put into a cell that would read the pt drop-down values (there should only be one) and display it in the cell? I would put this on the top of the page so I could glance at it and know everything refreshed properly instead of having to hit the drop-down and then close it again (too many worksheets in this book). I hope that made sense to someone. Any suggestions? Thanks, Lou Sanderson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
pivot table layout | Excel Discussion (Misc queries) | |||
drop down arrow missing from Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |