![]() |
Working for Some but not Others
Looking to continue this research from yesterday. Any ideas why it works for
some and not others? Ken -----------------Yesterday's Log-------------------------------- Hi Jim, I do have that selected on all my pivot tabs and it works fine when working from within those tabs. The problem is this.... I have a "Dashboard" tab (with =GETPIVOTDATA formulas) that acts like a summary page, so they can look at the overall picture. Now, when I click on one of the getpivot cells (on the Dashboard) it will bring me to the pivot tab where it is pulling the data from. Unfortunately, this feature/functon only works for some and not others. Hopefully I've explained it well enough. Any ideas why it works for some and not others? Ken "Jim Thomlinson" wrote: In the PivotTable Options there is a check Box "Enable Drill to Details" that needs to be checked. -- HTH... Jim Thomlinson "Ken" wrote: The situation is this... Some of the people viewing my reports can click on the individual cells/data value and it opens a new sheet revealing the related pivot data (or it directs them to my pivot table). That said, others who do the same only get the underlying formula displayed. It's almost like there is a feature that needs to be turned on or maybe a patch that needs to be installed. Can anyone tell me why some people can click to display the data and others can't? Appreciate the help. Ken -------------------------------------------------------------------------- |
All times are GMT +1. The time now is 12:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com