Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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
add comment

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.