pivot table formatting

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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 =...
  6. 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" -...
  7. 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...
  8. 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...
  9. 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
  10. 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...
  11. 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...
  12. 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 =...
  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. 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...
  15. 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...

Some videos you may like

This Week's Hot Topics

Top