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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top