Forum

Hi Alan, When using conditional formatting with PivotTables you need to set it up in a particular way which is described in this tutorial on conditi...

Hi Dan, You can combine all or select workbooks in a single folder, or you can combine all or select sheets in a single file. However, if you want ...

Hi Dieneba, Slicers apply filters to PivotTables. The PivotTable Connections dialog enables you to specify which PivotTables you want that Slicer t...

Hi Michele, There's currently no way to link the minimum start date on the horizontal axis in your chart to a cell and because of the way the chart...

Hi Doug, Why would you want to model it in VBA when a formula does the job? I recommend avoiding VBA unless absolutely necessary. Typically built-i...

Hi Felix, Welcome to our forum! Unfortunately, there's no way to specify the background colour in the Power Pivot window. That was filmed in an ...

Hi Peg, Welcome to our forum! It sounds like you're using all the relevant tools for protecting your data integrity. Obviously, you can't preven...

Hi Lenka, Welcome to our forum! Correct, the data split over multiple sheets means you cannot connect a single slicer to each PivotTable. Instea...

Hi Doug, You can use INDEX & MATCH with COUNTIF for this. See file attached. Mynda

Hi Cynthia, Thanks for sharing your file. The problem is the dates in column A of the Data Table are text and Excel can't read them as dates. They ...

Hi Doug, Please upload a sample Excel file. Be sure to include a few students' data so we can see the layout of the table. I think you can use a fo...

Hi Kelli, Welcome to our forum! That's odd. Are you logged in? Mynda

Hi Anita, I think Jessica is picturing the data in PQ is in separate columns as it appears in your screenshot, but presumably you have one column c...

Hi Michele, If you look at my Project Management dashboard you can modify it so that the Project name appears in the highlighted cells instead of j...

Hi Anita, What you want to do is group AV together and PV together and then take one group from the other, but when you group items in regular Pivo...