LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default MS Excel 2003 Pivot Table question

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.

Tauni wrote:
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.



--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
MS Excel 2003 - pivot table Petka Nemcova Excel Discussion (Misc queries) 1 February 12th 09 10:53 AM
Excel 2003 Pivot Table Nydia Excel Discussion (Misc queries) 1 September 9th 08 11:04 PM
Excel Pivot Table Refresh Question David D Excel Discussion (Misc queries) 2 August 25th 05 01:00 PM
Excel Pivot Table Question Tom Excel Discussion (Misc queries) 0 August 2nd 05 06:31 PM
Can links between Excel 2003 Pivot Charts and their pivot table b. Mark Allen Charts and Charting in Excel 2 March 5th 05 05:24 PM


All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"