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