filters

  1. S

    Excel Formula to Link Pivot Filter with a Cell

    Dear All, Is there a way to link a cell to Pivot Filter with Excel Formula. I have gone through the VBA but its clearing all the Filters which is not suitable for me as I do have few filters which I do not want to clear. Hence requesting your expertise for excel formula which can control Pivot...
  2. T

    Remove all filters and or tables from several files at once

    Good evening chaps, I have an issue at hand, I'm trying to merge several files at once they are all located in the same folder which makes the task at hand easier, however some of the files have filters and or tables thus such files will only copy the filtered information when I actually need...
  3. M

    Filtering a Chart - hopefully using a VBA drop-down or pop up rather than filter a table?

    Hiya Had some great help on here recently and have managed to build exactly what my boss wanted! Problem is they always want more don't they!!! I have created an automated and dynamic chart that displays data for Week 1 through to Week 52 for several different products. Spread across the year...
  4. A

    copy/paste related question when filter is on

    Hi there, I am having hard time understanding, how does excel work when i do copy paste some data into a table that has its filters on (meaning, few rows are hidden due to filters on header). Here is what i did when felt like its not working consistently & have experimented & results confused...
  5. R

    Missing table - How is this even possible?

    I have a formula that references a table inside the file I'm working in, but I don't see the table in the Name Manager. All filters have been cleared. How is this even possible? I thought all tables were referenced in Name Manager.
  6. Ferreira1456

    Advanced filter unique do not working properly.

    For some reason advanced filter unique do not working properly. Could you please help me? Please take at look on my Macro and show me where is the problem. One of the error is the very first one. Public Sub CustomerList() Dim rngData As Range Dim lin As Long Dim li...
  7. S

    Filter on Blanks not working

    Hello, I have a pivot of info (as below). I have a master copy which i save every week by week number and dump in data from an external source. I want to filter "Time Into Loading" and "Time Finished Loading" so that it filters out and blank cells, however when new data is entered into the...
  8. S

    Excel Olap PowerPivot Filters

    When removing some field items from your pivot table based on an olap query, I noticed some filters automatically clear, where as others remain and you must find them on the field list and clear them manually. I'm not sure what the driver here is... does anyone have an idea? google has not...
  9. V

    Comparing 2 Pivot Tables on same excel sheet

    I am not sure if what I am asking for is even possible but I would like to compare sales data from two different years with 1 chart on top of the other. The issue I am running into is when change my filters on the top report it can run into my second pivot table causing an error saying a pivot...
  10. drom

    Clear multiple filters within the same tab/sheet

    []Hi and thanks in advance![/b] I have a tab/sheet with multiple different tables some time I have to filter a table and I do forget to clear the filters when moving to one other sheet and saving the Book Takes me quite lot time and is so tedious to check in which table I have applied filters...
  11. T

    How to Remove Data Drop Downs in Pivot Table after deleting data

    I set up some pivot table templates in an excel file and I want to share the file with some people, the problem is even though I deleted all of my raw data if they look in the pivot table filters, some of the data is still there. How can I get that data to be removed from the pivot table when...
  12. N

    clear active filter from all columns except for active column

    Good day all, i have a question. I use excel filters all day long. I usually apply it to huge data tables on many columns simultaneously. It would help if i have a method or Macro which will remove all active filters except from the columns of active cell. Let me explain !!! Say i have...
  13. S

    Pivot table filters lost

    Hi all, I have made a dashboard consisting of pivot tables filtered by day of the week. I wanted to have a master copy that I could dump data in from an external source. When I remove the data used to create the pivots and replace with the new weeks data, the filters are lost and I have to...
  14. B

    UGH! Help! Pivot table filter keeps resetting

    I have multiple pivot tables in a workbook that are all connected to the same source date. (It happens to be an OLAP cube, but I don't think that is the issue). So, since they are all connected to the same data, when I choose "refresh" on one of them then all the pivot tables refresh. The...
  15. C

    Help on Pivot Table

    Hi! I'm having a problem arranging a pivot table report in a simple layout. Can anyone help? So, I have a (quite big) set of data in this format: <colgroup><col><col><col><col span="48"></colgroup><tbody> Client Department Employee 1MAT 1H 1OT 1TOT 2MAT 2H 2OT 2TOT 3MAT 3H 3OT 3TOT 4MAT 4H 4OT...
  16. D

    VBA to change filter values in pivot tables

    Hello, I have a worksheet with multiple pivot tables, and I have 3 report filters: Level 1, Level 2, and Level 3. Everytime I modify each of these 3 filters to get my data. Is there a VBA code where I can modify each of those 3 filters based on cell values for them respectively? Any help on...
  17. S

    Slicer for multiple pivots

    Hello, I have a few pivots all sorted by dates and regularly filter using the "this week" "last week" filters. Is it possible to create a slicer to do this? or something similar? Thanks Stephen
  18. S

    "ALL" doesn't seem to work when I have filters inside my query

    I'm trying to do a time series line chart where I have 3 lines: 1 line for "Plan" state performance, 1 line for "Forecast" state performance. I have a main slicer that I can toggle for various states (i,e TX, AR, etc etc). I also want one more line, that is the "National" line, which is the...
  19. AsgiE

    Multiple Field Filter using Combo Box Form Control and VBA - Code Error at Multiple Filter Selection

    Greetings, I am building a front end filter page where users can select multiple filters using Combo Boxes linked to a database of information in a tab. I am then using VBA to extract the filtered database to another file. I have used and IF, Then, Else approach to cycle through the filters to...

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
Back
Top