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?