Making pivot tables update automatically.
Posted by Paul on June 03, 2001 6:17 AM
I have just starting to use pivot tables, I put one in one of by workbooks the sheet name is "Table", and as you know it does not update itself, is there some code that would make the tables update when I select the worksheet? If so where would it go? I don't know much about VBA. Thanks for your help.