 |
 | 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 / General Excel Questions / May 2008preserve formatting option in pivot table option dialog box
Anyone know what the "Preserve formatting" checkbox does in the pivot table dialog box? I was just asked this by a colleague and I have no clue....  SignatureBrevity is the soul of wit. If you don't have that option checked, some of the pivot table formatting may be lost when you refresh the pivot table. > Anyone know what the "Preserve formatting" checkbox does in the pivot table > dialog box? I was just asked this by a colleague and I have no clue.... SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html That would make sense, thanks. SignatureBrevity is the soul of wit. > If you don't have that option checked, some of the pivot table > formatting may be lost when you refresh the pivot table. > > > Anyone know what the "Preserve formatting" checkbox does in the pivot table > > dialog box? I was just asked this by a colleague and I have no clue.... No matter if "Preserve Formatting" is checked or not, some, not all of my formatting of pivot tables gets lost after refresh (Excel 2002). Somebody once also said "Enable Selection" affects the formatting....that doesn't work either. Is there a definitive source on how to format and pivot table and have the formatting hold? Thanks > If you don't have that option checked, some of the pivot table > formatting may be lost when you refresh the pivot table. > > > Anyone know what the "Preserve formatting" checkbox does in the pivot table > > dialog box? I was just asked this by a colleague and I have no clue.... I get the message "The Enable Selection button on the Select submenu (Pivot table menu) is not pressed in." I have tried every way possible and do not see how to press in this button. My company has a really old version of Excel 97 SR-2. It has been many years since I worked with this version. HELP! Every time I refresh, it takes away the formatting on my pivot. > If you don't have that option checked, some of the pivot table > formatting may be lost when you refresh the pivot table. > > > Anyone know what the "Preserve formatting" checkbox does in the pivot table > > dialog box? I was just asked this by a colleague and I have no clue.... |
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.