+ Reply to Thread
Results 1 to 3 of 3

Formatting lost on Pivot Table

  1. #1
    Forum Contributor
    Join Date
    02-12-2018
    Location
    TX
    MS-Off Ver
    MS Office 2019
    Posts
    305

    Formatting lost on Pivot Table

    Hello. The attached sheet is losing its cell alignment when I click the Reset button or when I click the button to copy/paste to another sheet (Add to BOM). I have no clue how to fix this and I've been searching everywhere. Anyone have a solution? Could really use the help. Much appreciated. Tks.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,636

    Re: Formatting lost on Pivot Table

    cell alignment is part of formatting
    so if you use pastevalues
    Please Login or Register  to view this content.
    you are not copying formatting?
    if you only want cell alignment and nothing else
    far easier to just apply cell alignment after you have pasted values

    ps
    shouldnt you be using .Range("B" & Rows.Count).End(xlUp) to get last row? As A is empty? or are you intentionally not copying the bom line?
    Last edited by humdingaling; 05-17-2018 at 08:21 PM.
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    02-12-2018
    Location
    TX
    MS-Off Ver
    MS Office 2019
    Posts
    305

    Re: Formatting lost on Pivot Table

    Hi. Thanks for your help. I'm not sure that I'm clear on your questioning. I thought that I was already using the code you provided, but maybe I'm missing something. And my primary area of concern was the Dashboard sheet. It seems like maybe you're reference the BOM sheet. I lose cell alignment (center/bottom) on two of the rows when I use the silcers, click Reset, or click Add To BOM. I found some code online that I was hoping would work but currently isn't. Maybe someone could look at it and tweak it? (Attached). Thanks again for the help.
    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)

Similar Threads

  1. Replies: 0
    Last Post: 08-31-2017, 10:40 AM
  2. lost connection power pivot table
    By pccamara in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-13-2017, 12:35 PM
  3. Cell background lost when pivot table is expanded
    By xrayexceller in forum Excel General
    Replies: 0
    Last Post: 07-28-2013, 07:40 PM
  4. Have the pivot table, lost the raw data!
    By Psamskid in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-16-2013, 10:47 PM
  5. Replies: 1
    Last Post: 09-07-2011, 03:32 PM
  6. LOST!! Chart? Pivot table? Formula?
    By Ed in forum Excel General
    Replies: 4
    Last Post: 02-21-2006, 03:50 PM
  7. calculated fields pivot table - i am lost
    By MD in forum Excel General
    Replies: 1
    Last Post: 02-02-2006, 08:55 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