pivot table formatting

  1. A

    Protect sheet and disable manual edits to pivot table but allow Slicers

    Not sure if this is possible but what i want to do is as follows: Unprotect sheet, refresh data on pivot table on sheet, filter out 3 items and then protect sheet. However after the sheet is protected I want it to be editeable by a Slicer but the user cannot manually override any data in the...
  2. F

    Converting listed data to pivot table format - repeatedly copying and pasting between two specified instances

    Hi Everyone, I am no VBA expert and appreciate any help you can provide. I would like to learn how to search for a before and after instance to copy and paste information in between those two instances. And then repeat the process. This helps to create a format usable for a pivot table. For...
  3. L

    Pivot Table Text instead of Numbers in Values

    Hello Is it possible to get a text instead of a # in the Values section of a pivot table? I have Power Pivot installed because I read that it can help. However I have never used it before and am having a hard time figuring out how to create a pivot table with the data I uploaded (a power...
  4. R

    Resize pivot table column without affecting cells outside the pivot table

    I have a sheet with 4 pivot tables on it. Three of them are in a row above the fourth. The fourth one that is on the bottom displays text responses, some of which are long. I want this pivot table, with the text responses to resize to fit these responses, when I select different filters, without...
  5. M

    Retain Pivot Table Formatting

    I've seen many posts about retaining the pivot table formatting when pasting values to unlink it from the source. The paste special values does not work. I've tried using the clipboard to paste and it worked one time. In the same workbook attempting to copy and paste the values and formatting...
  6. J

    VBA macro to format Pivot table fields

    I am trying to write a macro which would format all pivot table fields that start with "Count of" as a number and all that start with "Sum of" as currency. This is the code I have so far, but I doesn't quite work: Sub FormatPivot1() Dim pt As PivotTable Set pt =...
  7. A

    Locking Formats in Pivot Table Excell 2007

    Hi, I am trying to lock down formatting in a pivot table within Excel 2007. I would like to retain all formatting i.e. colours, font, column width etc - is this even possible? I have hunted high and low and the answer seems to be to make sure that "preserve formatting on refresh is selected" -...
  8. C

    How to tell Excel only to read one data field that repeats throughout and excel spreadsheet.

    Ok let me see if I can explain this right. I have a data dump that is in form that you can create a pivot table off of. What I am trying to do is to get the pivot table to only read the data that repeats once. So if you can see the column belows title is mawb and then below it are the cells...
  9. T

    Need to change Pivot Table Field Settings

    I currently have a sales forecasting report that I create each month, which contains statistical data for the prior months, as well as forecasting fields for the new months. When I create a pivot table for the statistical data, the field settings default to COUNT and I need them to all be...
  10. S

    PivotTable Formatting

    I have lost the little arrow that allows formatting in PivotTables. I cannot fill, outline, or anything only the columns or rows in the data. Any suggestions on how to get this back? Co-workers using same file can do this. Thanks
  11. T

    Pivot Table will not Keep Formatting from Pivot Detail

    I am going to try to ask my question another way b/c I have not received any response to my 1st question. Is there a way in excel 2007 to keep all formatting (including highlights) of the pivot detail when selecting cells in a pivot table? Currently my pivot table will pull the detail but does...
  12. M

    Calculated Field number format in VBA

    Hi! How do you format PivotTable Calculated Field numbers in VBA? I'm trying to format the numbers so that all the actual numbers show with two decimals and plain zeroes show as "". The .NumberFormat = "# ###.##" seems to work in all the normal data fields but with the Calculated Fields this...
  13. G

    Pivot Table “Muscle Memory” Problem

    I am somewhat of a novice with Pivot Tables. One problem I am having that no one seems able to help me out with is that when I update and refresh my pivot table, it seems like it has a muscle memory with the drop down choice boxes. <?xml:namespace prefix = o ns =...
  14. G

    Pivot Table “Muscle Memory” Problem

    I am somewhat of a novice with Pivot Tables. One problem I am having that no one seems able to help me out with is that when I update and refresh my pivot table, it seems like it has a muscle memory with the drop down choice boxes. <?xml:namespace prefix = o ns =...
  15. M

    Pivot Table: Do not display blank rows

    I have a sheet with names and options and I need to create a receipt of each person based on their choices However I do not want to print out blank choices as there are over 300 of these and each name may choose between 1 or more. Usually no more than 6 but i need to take into account the guy...
  16. S

    Pivot Table - Field Settings - Number Option to Format Missing

    I have a problem, I have several Pivot Tables, on some of the Pivot Tables, I am able to select the Pivot Table Filed Option, and use the Selection for Number to change the formating for this Row Data. On several other of my Pivot Tables, this option does not exist. Does anyone know why this...

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