Second way don't work in my file. Compile error: User-defined type not defined. I've chenged "SasAddinObj As SASAddin" to "Dim SasAddinObj As SASExcelAddIn". I have error: Run-time error '9': Subscript out of range. Please help me to refresh Pivot table with VBA.
... View more