formatting pivot

  1. F

    Pivot Table - Need to Lock Formatting

    Every time I refresh my pivot table the formatting changes. I have gone into Table Options and unchecked "Auto Format Table" and checked "Preserve Formatting"....but it still changes formatting every single time. What is going on here? How do I stop the PT from reformatting on every refresh...
  2. T

    Preserve source data formatting in pivot table

    I have a worksheet with a "Rates" column containing cells of various formats. Some are General, some are Percent, some are Currency, some are Text, etc. When this column is pulled into a pivot table, the original formatting is lost and the entire column appears in General format. Is there a way...
  3. B

    Pivot table VBA Macro for Overtime Report

    Hello All, I am sure this is pretty basic, but I have been searching the forum all day trying to find the answers. I could also use some help cleaning up my current macro, but I will leave that for the end. I am basically trying to create a basic pivot table using the data I have in...
  4. B

    Pivot table VBA Macro for Overtime Report

    Hello All, I am sure this is pretty basic, but I have been searching the forum all day trying to find the answers. I could also use some help cleaning up my current macro, but I will leave that for the end. I am basically trying to create a basic pivot table using the data I have in...
  5. J

    drilling down in pivot tables

    Hello all... I am using the drill down option in pivot tables whereby you can double click on a value in the table and it opens up a separate sheet with the information used to calculate the value. Only problem is that in the sheet that comes up, you loose all the formatting of the original...
  6. E

    Pivot Table Extraction Formatting

    Hi, I have a query that is doing my head and cannot solve, and I hate that! I have a pivot table based on a certain data set. When I double click on a cell in the data section to extract the data into a new worksheet, the format of the data in the new sheet is completely different to the...
  7. T

    Conditional Formatting in a Pivot

    Hi all, Usally I find the solution of my problem reading the other threads, but not today... probably because I'm not a VBA expert... I'm trying to figure out how I can set a conditional formatting in a pivot preventing the possible shift of the fields. My pivot is generated by a macro. The CF...

Some videos you may like

This Week's Hot Topics

Top