Home » Forums » Open Source Learning Center » Question and Answer

Hyperlink field in Pivot Table (xl 2007)

Submitted by deepakjipaulson on 16 November, 2011 - 10:40

Hi,

Myself using Excel 2007

Is it possible to have a hyperlinked rowlabel/column label in pivot table

AttachmentSize
Sample.xls60.5 KB
‹ how do I display the full path in excell 2010 Help need on VB ›
»
Nick's picture

why would you need this...

Submitted by Nick on 17 November, 2011 - 15:21.

why would you need this... simply double click on the data, and the results that go into that calculation appear

»

Hyperlink in Pivot Table (xl 2007)

Submitted by Anonymous on 19 November, 2011 - 07:46.

Hi Nick,

I need to present financials (Bal Sheet)

Here it goes :
Under Asstes few groups & Liabilities few others
Each group has, say 10-15 account codes

Its impossible for me to download the whole transction file and make a pivot out of it.
But I have got the Account total from the trial balance along with few notes

When I click on the code it should take me to the Schedule sheet...

What I need is - Exactly a treeview
I understand, That is not easy..

Awaiting your reply..

Regards,
Deepak Ji Paulson
Kuwait

»

why can't you create a pivot

Submitted by Anonymous on 21 November, 2011 - 09:02.

why can't you create a pivot out of it ?

»

Hyperlink in Pivot

Submitted by Anonymous on 21 November, 2011 - 10:39.

I can very well do that... But I want to include a schedule as well

»

pls add an example file to

Submitted by Anonymous on 21 November, 2011 - 10:54.

pls add an example file to your post

»

Hyperlink in Pivot / Tree view using VBA

Submitted by deepakjipaulson on 24 November, 2011 - 10:35.

Pls. refer to the file attached in the first post

File name : sample.xls

Thanks

»
Nick's picture

does double clicking on the

Submitted by Nick on 24 November, 2011 - 10:58.

does double clicking on the value in the YTD column not bring u the right values ?

»

Hyperlink in Pivot

Submitted by Anonymous on 27 November, 2011 - 10:26.

Hi Nick,

Double click will open a new sheet showing the same YTD value

What I need is a SCHEDULE sheet..

Kindly refer the notes in the sameple.xls file

Awaiting your reply

»
Nick's picture

unless the data you refer to

Submitted by Nick on 27 November, 2011 - 19:23.

unless the data you refer to was used in the creation of the pivot table, it won't be possible to back it out..

»

Tree view

Submitted by Anonymous on 28 November, 2011 - 10:15.

Thanks Nick

Is this possible using a treeview ???

»
Nick's picture

if you don't have the

Submitted by Nick on 28 November, 2011 - 11:17.

if you don't have the underlying data, it's not possible at all.

What I am saying is this:

You have Sale 1 = 100, Sale 2 = 300
Total = 400

- If you only have the 400 data, you can't back out Sale 1 and Sale 2 whatever you do...

»