Pivot Table in Pop-up Window

[KH_03]

Hi Everyone,

Im newbie in the site. Ive read and learn a lot from your website.

I need your help, i want to show the pivot table (sheet name: Pivot table) i created in a pop-up window, which will be automatic (i mean no triggering button to execute the pop-up window). The table will be change depends on the data (sheet name: FORM 1)

Hope you could help.

I will upload a file for better understanding.

Hope for your support.

More Power!

regards,
KH_03

 

[Hui]

KH_03

Firstly, Welcome to the Chandoo.org Forums

A few questions:

Why do you want it in a pop-up window?

Would simply moving the user to the Pivot Table worksheet when a certain event occurs suffice?

Do you still want the Pop-up widow to have the ability to shrink or expand a selection like W45 is in your example or simply display all the data?

 

[kchiba]

KH_03,

The attached file has a pivot table, with a Report Filter in Row B.

Changing the Project would change the Pivot

 

[KH_03]

KH_03

Firstly, Welcome to the Chandoo.org Forums

A few questions:

Why do you want it in a pop-up window?

Would simply moving the user to the Pivot Table worksheet when a certain event occurs suffice?

Do you still want the Pop-up widow to have the ability to shrink or expand a selection like W45 is in your example or simply display all the data?

Hi Hui,

Thanks!

I want to maximize the view of the spreadsheet, currently i only doing "new window" to view the 2 sheets (Pivot table & Form 1) at the same time. I can put the Pivot table in the pop-up window, i could move the pop-up window upper most of the screen for me to see the whole spread sheet of Form1 (by the way, Form1 has many data, it extend up to 15-20 rows).

Yes in the 2nd question. i Just want to view only all the data.

More power

regards,
KEL

 

[KH_03]

KH_03,

The attached file has a pivot table, with a Report Filter in Row B.

Changing the Project would change the Pivot

Hi Kchiba,

Appreciate your help. thanks a lot. I need to have pivot table in the pop-up window. So that i can maximize the space of the Form1 spreadsheet.

regards,
KEL

 

[kchiba]

Hi KH_03,

OK, you can try the Camera functionality in Excel, this will create a picture of your Pivot Table that you can drag aground the sheet.

Hope this helps.
kanti

 

[kchiba]

Hi Kel,

Here is your file with the "Photo" of the Pivot

 

[KH_03]

Hi Hui & Kanti,

I just found out that the file i upload is not the updated one. Im sorry. attached is the latest. i added Current and Goal (3rd sheet) sheet to visually see my current and goal.

by the way the pivot table is auto-refresh.

hope it clears now.

 

[kchiba]

Hi Kel,

I have used the Camera in Excel, to take a snapshot of the Pivot Table, and copied it to both your other sheets. The snapshot would update as the Pivot is updated.