A
Adam
I have a standard data sheet with dates, info, and
website. I have built them into a pivot table but have
had some problems formatting it. it llooks like this
date Category Link
3/4/03 NEWS http://www.link.com
3/5/03 NEWS http://www.link.com
NEWS http://www.link.com
3/6/03 NEWS http://www.link.com
now my problem is that the dates do not show up in every
entry. The third entry down should say 3/5/03 but since
the one above it is the same date it automatically omits
it. I can find no way to fix this. Second, the link in
the pivot table is not a hyperlink. The original data has
hyperlinks but when coverted into a pivot table it only
shows the text. Is there even a way to make hyperlinks in
a pivot table? Any help would be greatly appreciated.
Thanks
website. I have built them into a pivot table but have
had some problems formatting it. it llooks like this
date Category Link
3/4/03 NEWS http://www.link.com
3/5/03 NEWS http://www.link.com
NEWS http://www.link.com
3/6/03 NEWS http://www.link.com
now my problem is that the dates do not show up in every
entry. The third entry down should say 3/5/03 but since
the one above it is the same date it automatically omits
it. I can find no way to fix this. Second, the link in
the pivot table is not a hyperlink. The original data has
hyperlinks but when coverted into a pivot table it only
shows the text. Is there even a way to make hyperlinks in
a pivot table? Any help would be greatly appreciated.
Thanks