I am developing add-in for excel and trying to read pivot tables but found no access to pivot tables from the worksheet , strangely pivot table can be reached from non add-in projects , I will be grateful if any one give me some info or code.
I am developing add-in for excel and trying to read pivot tables but found no access to pivot tables from the worksheet , strangely pivot table can be reached from non add-in projects , I will be grateful if any one give me some info or code.