Display an active pivot table in excel 2010 userform

Tazyote

New Member
Joined
Jan 14, 2014
Messages
14
I cannot figure out for the life of me why Microsoft decided to remove the additional control for Microsoft Office Pivot table 11.0 when they updated excel 2003. Why would they take away options? In any case, this has left me with a serious problem as our office upgrades to 2010. Our entire company uses a userform which I have run custom pivots from that will no longer be of use in 2010. I have found where I can download the Microsoft Web components for 2003, but the problem is that the rest of the company has locked computers. Does anyone know of code that would display an active pivot table in a userform without downloading the web components? Showing the table on the worksheet is not an option because users do not know how to use them and than mess it up generating calls to the help desk. Thoughts?
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.

Forum statistics

Threads
1,214,979
Messages
6,122,550
Members
449,088
Latest member
davidcom

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top