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've made a Pivot Table that has one column called Issue Id.

I would like to add a column to this table with the following formula:

=HYPERLINK(CONCATENATE("website.com/", 'Issue Id'), 'Issue Id')

So for example if the Issue Id is Y-19, the field would display Y-19, and when you click on it, it would take you to website.com/Y-19.

I've tried this on a regular table and it works, but not on a Pivot Table. Excel thinks the formula is wrong...

share|improve this question

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.