I have a pivot table which filters on a field list. There is a filter icon on the 'Type' field. When I open the filter to view there is a Label & Value filter listed. What is the difference between these two types and how are they enabled or disabled?
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.