I have a macro that filters a pivot table and copies the pivot to individual
tabs, one tab for each filter item. I tried to copy the filtered criteria and
enter it directly into the NAME cell of the Properties window of each tab,
this method works manually but the macro wont allow it, any ideas why?