Hello,

I am trying to use the following bit of code and I am having trouble. I
believe I am missing a reference in the tools menu because when I type
ActiveSheet. nothing appears afterwards. If I had the right library loaded
then it should appear. Does anyone have any ideas of how I can find out which
library to use?

ActiveSheet.PivotTables("FocusMktList").RefreshTab le

These are the libraries that I have loaded
- Visual Basic For Applications
- Microsoft Excel 9.0
- OLE Automation
- Mcirosoft Office 9.0
- Microsoft Forms 2.0 Library