I have a report with several pivot tabs and one "Dashboard" tab for a quick
view of everything.

My situation is this...

Some of my coworkers can click on the individual cells/data on the Dashboard
tab(that have my formula calculations and Getpivot Data) and it brings them
directly to the pivot (where the data was pulled from), yet others click on
the cell and it just gives them my formula. Why can some get to the pivot
data and others can't?

Appreciate the help.

Ken