Hi fellow Excel geeks. I recently switched to Excel 2016, so I'm not sure how to handle a VBA issue. I'm making a report for our low-level managers, many of whom don't have great computer skills, so I want to make it as easy as possible. They copy data exported from our database into a tab. The important stuff is then pulled into another tab that is protected, and contains a pivot table. What I want is a button they can push on the protected sheet that unprotects the sheet, refreshed the pivot table, and then re-protects the sheet. I don't want to button on the unprotected sheet, because if they copy all when moving the data over it might be covered over. But so far my attempts to get a macro to do that has failed. I'd also like it to filter on the pivot table to exclude blank rows but to keep all other values (which will change on a daily basis). Can anyone help me out?