Couldn't Create Pivot Cache in another workbook.

**shiva_raj** · 12-17-2018, 02:12 AM

Hi,

I wrote a Pivot code in "ABC" workbook. By using code I want to open another existing Workbook say "XYZ" and create Pivot based on the data in "XYZ" file. While I running the code it showing at Pivot cache code as "Run-Time error '424': Object Required".

Please go through the code which is copied in the text file.

Thank you in advance.

regards
shiva

**romperstomper** · 12-17-2018, 04:16 AM

Which specific line causes the error, and why are you trying to create two pivot tables in the same place?

**shiva_raj** · 12-17-2018, 04:28 AM

Thank you for reply.

I changed the code little bit. i wrote the code in "ABC" file. I created pivot based on data which is in other workbook say "XYZ". At this time error occur at xlDatafield

Please Login or Register  to view this content.

regards
shiva

**romperstomper** · 12-17-2018, 05:10 AM

What is the error?

Couldn't Create Pivot Cache in another workbook.

LinkBack

Thread Tools

Rate This Thread

Display

Couldn't Create Pivot Cache in another workbook.

Re: Couldn't Create Pivot Cache in another workbook.

Re: Couldn't Create Pivot Cache in another workbook.

Re: Couldn't Create Pivot Cache in another workbook.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to determine if Pivot Table Cache Index is used elsewhere in Workbook

VBA to create an Pivot table using an existing Cache

[SOLVED] Macro to update pivot tables and use the SAME cache instead of repeatedly recreating cache

Unable to clear pivot cache without reopening the workbook

Macro to create common cache for groups of pivot tables

Create multiple pivot tables from pivot cache

Create the Pivot cache and pivot macro

Bookmarks

Bookmarks

Posting Permissions