By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 917 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Open Pivot Table in Pivot Table View

P: n/a
Hi,

Hoping someone can help. I have created a pivot table and launch it via a
command button. Unfortunately, it opens in form view and not in pivot table
view. I have opened the form in design view and set the default view to
pivot table but still no luck. I have searched Google but no help there
either. Any help/advice appreciated.
--
SharkFOA

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi all,

Found answer, a bit of a workaround but it solved it. Exported it as data
access page and changed the command button to open page. Sorry, should have
said before it's OfficeXP.Any other ideas welcome as it may help others.

--
SharkFOA
"SharkFOA" <sp**@spam.tw.uk> wrote in message news:3f******@clear.net.nz...
Hi,

Hoping someone can help. I have created a pivot table and launch it via a
command button. Unfortunately, it opens in form view and not in pivot table view. I have opened the form in design view and set the default view to
pivot table but still no luck. I have searched Google but no help there
either. Any help/advice appreciated.
--
SharkFOA


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.