MS Excel 2003 Pivot Table question

T

Tauni

Does anyone know how to insert a hyperlink into a pivot table without it
losing it's formatting? I can insert the link into the data sheet, but when
it refreshes it into the actual pivot table, it is no longer a link. It is
just a listing telling people where they can go to find the link.

I appreciate any thoughts anyone might have on this.
 
D

Debra Dalgleish

The items in a Pivot Table's row and column areas are text only. Even if
you have hyperlinks in the source data, those won't carry over to the
pivot table.
You could use a column with formulas outside the pivot table, to create
the hyperlinks. Use the HYPERLINK function, and refer to the cells in
the pivot table.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table - Changes 5
Question on the occupied field of the pivot table in excel spreadsheet 0
Cannot Open Pivot Table Source File 0
Excel 2003 Pivot Formatting 2
Excel 2003 - Can't format Pivot Table 1
Refreshing Pivot Tables 1
pivot table toolbar 1
Linking Pivot Table data 3

Top