Hello.
In my workbook, there resides a pivot table. Currently, I have a simple (very simple!) macro that refreshes the data. This is the code for that:
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
However, this is a shared workbook. In a shared workbook, I'm finding it difficult execute the macro while the workbook is in "shared" status.
Can anyone help me edit this code so that it will refresh the pivot table while the workbook is in shared status?
Thank you.
Rachel
In my workbook, there resides a pivot table. Currently, I have a simple (very simple!) macro that refreshes the data. This is the code for that:
ActiveSheet.PivotTables("PivotTable1").PivotCache.Refresh
However, this is a shared workbook. In a shared workbook, I'm finding it difficult execute the macro while the workbook is in "shared" status.
Can anyone help me edit this code so that it will refresh the pivot table while the workbook is in shared status?
Thank you.
Rachel
