Need help, I want my macro to select "(All)" in my pivot table, when I record this it lists all the locations under all as visible, but if there are new locations, the macro will not select it. Is there a way to have a select "(All)" in my macro?