title: How to prevent user multi-select in Excel pivot tables?
body: <p>I have an Excel pivot table that is date based.  I want to force users to 1 and only 1 year plus 1 and only 1 quarter for their reporting.  Is there anyway to do this in filters or slicers or should I brute force it in VBA.  I'm very comfortable with VBA in Access and Word, but haven't had much call to VBA in Excel.
  Thanks!</p>