Updating Pivot Tables in shared workbooks

kmiles · Apr 11th, 2002, 08:01 AM

Anyone know how to do this?

I tried using ThisWorkbook.RefreshAll method but got an 'Object method failed' error.

Thanks for any help.

Mudface · Apr 11th, 2002, 08:26 AM

You can't update pivot tables in shared workbooks, you would need to unshare them first. An alternative would be to link the data to a separate workbook and create the pivot table in that.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 11th, 2002, 08:01 AM	#1
kmiles Board Regular Join Date: Apr 2002 Posts: 113	Anyone know how to do this? I tried using ThisWorkbook.RefreshAll method but got an 'Object method failed' error. Thanks for any help.

Apr 11th, 2002, 08:26 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	You can't update pivot tables in shared workbooks, you would need to unshare them first. An alternative would be to link the data to a separate workbook and create the pivot table in that.