+ Reply to Thread
Results 1 to 1 of 1

Pivot Table Layout Issue moving from XL03 to XL07

  1. #1
    Registered User
    Join Date
    02-28-2010
    Location
    Boston, USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    Pivot Table Layout Issue moving from XL03 to XL07

    folks, I am unable to recreate the same pivot table layout in XL07 that I was able to create in XL03. the root of it seems to be related to the disappearance of XL03's autoformat function (report AND table templates) in favor of XL07's pivot table style sheets.

    I have attached a test-layout.xlsx (yes an XL07 workbook). the file was originally created in XL03 and pivoted in XL03 (pivot table on the left). then I opened the file in XL07 and pivoted the same data (pivot table on the right). It doesn't appear that XL07 has comparable autoformat reports / tables that XL03 has. instead XL07 has PivotTable Styles under the Design tab - looks like an endless supply of canned styles along with an ability to customize but i have been, so far, unsuccessful at removing the "Data" header that sits in the row immediately above the Sum of Qtr1, Qtr2 ... column headers with any sort of style change

    my workaround to this is to keep an XL03 formatted pivot table handy that I can copy and repoint to the correct source data as required but this seems somewhat inelegant. there has to be something I'm simply missing.

    I would be very grateful for any additional suggestions.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1