 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / April 2008classic pivottable layout
I want to know how can I set the default for the classic Pivottable layout in version 2007. I've tried the pivottable options > display tab and checked the Classic Pivottable layout, didn't work. ~thank you On the Options tab pf the PivotTable Tools, the leftmost group, PivotTable, click Options, then click Options. In that dialog, click the "Display" tab, and use the 4th checkbox, "Classic Picottable layout" Bob Umlas Excel MVP > I want to know how can I set the default for the classic Pivottable layout in > version 2007. I've tried the pivottable options > display tab and checked > the Classic Pivottable layout, didn't work. ~thank you I already tried that method, it works only for the current PivotTable next time I create a new one I have to manually change it again. perhaps it's the only way to set it up. thank you > On the Options tab pf the PivotTable Tools, the leftmost group, PivotTable, > click Options, then click Options. In that dialog, click the "Display" tab, [quoted text clipped - 5 lines] > > version 2007. I've tried the pivottable options > display tab and checked > > the Classic Pivottable layout, didn't work. ~thank you You can't change the default for that pivot table option. You can manually change it for each pivot table, or create a macro that changes the pivot table options. > I want to know how can I set the default for the classic Pivottable layout in > version 2007. I've tried the pivottable options > display tab and checked > the Classic Pivottable layout, didn't work. ~thank you  SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html thank you, I've been changing it manually I thought it would be a hidden default. thank you for your help > You can't change the default for that pivot table option. You can > manually change it for each pivot table, or create a macro that changes [quoted text clipped - 3 lines] > > version 2007. I've tried the pivottable options > display tab and checked > > the Classic Pivottable layout, didn't work. ~thank you |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.