ActiveWorkbook.PivotCaches.Create in Excel 2007

Joe

Guest

Posts: n/a

18th Mar 2010

Hello,

We just upgraded to 2007 from 2003 and now my pivot tables don't get create.
I get an error: Type mismatch when calling Create.

Set pivotDataRange = dataSheet.UsedRange
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase,
SourceData:=pivotDataRange)

Is there a change that no longer allows a range to be set as the SourceData?

Thanks,
Joe

« GetObjects chokes on apostrophe. | Copy and paste »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
1004 error with ActiveWorkbook.PivotCaches.Add	Jim Snyder	General Software	0	25th Sep 2009 06:07 PM
2003 to 2007 , ActiveWorkbook.ReadOnly	EXCELMACROS	Microsoft Excel Programming	0	19th Jan 2009 07:18 PM
Re: ActiveWorkbook.Close Dont Work in Excel 2007	K	Microsoft Excel Programming	0	21st Aug 2008 11:00 AM
ActiveWorkbook.SaveAs in excel 2007	=?Utf-8?B?THAxMg==?=	Microsoft Excel Programming	4	15th Aug 2007 06:56 AM
RE: Why is the Excel Addin the Activeworkbook	=?Utf-8?B?RXRoYW4gU3RyYXVzcw==?=	Microsoft Excel Programming	0	22nd Sep 2005 06:15 PM