ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Working for Some but not Others (https://www.excelbanter.com/excel-discussion-misc-queries/186824-working-some-but-not-others.html)

Ken

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