Hi.
I am on Excel 2010. I currently have recorded a macros to refresh a pivottable. However, one of the field in the pivottable had already been filtered. I would like my macros to first "select all" before refreshing the table. How do I amend the macros text/syntax to do so?
I have tried recording the actions to "select all" but it didn't appear on the written macros. Thanks.
Bookmarks