Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have an Excel pivot table with a SQL data source. One column of my data is the path and filename of an image. I'd like the user to be able to click to open the image when they are in the details view of the pivot data.

I tried to format the column like =Hyperlink("file://path/file", "Click to open") and it came through in the details but is not an Excel formula, it just looks like text. If I click that cell and then hit enter, it turns it into a formula and the link works.

Is there a better way to get a clickable link to an image in the details of the pivot table?

share|improve this question

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.