+ Reply to Thread
Results 1 to 2 of 2

Excel 2010 pivot table formatting not preserved after update

  1. #1
    Forum Contributor
    Join Date
    10-27-2009
    Location
    San Diego California
    MS-Off Ver
    Excel 2010
    Posts
    160

    Excel 2010 pivot table formatting not preserved after update

    I have looked all over for a solution to this. I have a quantity - thick/dia - width - length fields used as row labels, I would like each cell to have a border, after each update I get negative results to preserve the cell border formatting. Col b,c,d,e continually lose their cell border formatting after updating the data.
    Hope the attachment gives enough info to help. Thanks.
    ATTACH]286688[/ATTACH]

  2. #2
    Forum Contributor noboffinme's Avatar
    Join Date
    08-29-2013
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003/7/10/13/16/19
    Posts
    1,067

    Re: Excel 2010 pivot table formatting not preserved after update

    Hi MARKSTRO,

    I agree & have found this really annoying & unfortunately I'm not aware of how to keep the formatting in a pivot.
    Remember you are unique, like everyone else

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formatting not preserved in web query Excel 2007
    By Methodician in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-05-2013, 01:36 PM
  2. Pivot table removes formatting on update
    By ThomasCarter in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-21-2012, 11:35 AM
  3. Replies: 1
    Last Post: 08-22-2012, 07:46 AM
  4. Update data but keep pivot table formatting
    By Racer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-10-2010, 12:58 AM
  5. pivot table. why does the formatting change on update
    By saadeet in forum Excel General
    Replies: 9
    Last Post: 03-03-2007, 09:59 AM

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