'Good afternoon all,
I'm looking to conditionally format the below pivot table based on 0s on consecutive dates for each person. One consecutive '0', I want highlighted in pink, if it is 2nd consecutive '0' highlighted in red, and 3rd consecutive '0' or more, highlighted in a darker red. Also...
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...
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...
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...
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...
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...
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 =...
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" -...
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...
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...
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
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...
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...
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 =...
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 =...
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...
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...
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.