Hi! Thanks in advance for any help you may offer.

I'm using Office 2010 for info. I have a spreadsheet which is in use by my users. I want them to use the pivot tables I have added to it but I want to add a button that returns the pivot to it's original state - prior to the changes they made. My problem is that I'm finding it very difficult to find out how to do this. I don't seem to be able to find a good resource on the internet for the synatx. My code so far looks like this:

Please Login or Register  to view this content.
I want the year and month fields to be a report filter. I want regions across the top and Agent names down the side. My problem with the above is it's clunky and horrid ... ie hiding then unhiding fields.

Any help would be much appreciated even if it's a good resource on the internet.