I have the first page where people PASTE info into 4 columns and then on a second page a pivot table sorts and organizes the information. I have hidden the pivot table so users cannot screw it up and made links to the numbers in the pivot table in columns that they can see. My problem is that I need them to be able to refresh the pivot table once they have pasted their info in the first sheet. I know there is a Auto Refresh but they would have to save and open the file again for that to work.
I need a button to refresh the pivot table?
Can someone help?
Bookmarks