Avatar of RWayneH
RWayneH
Flag for United States of America asked on

Creating a Pivot Table

This used to work, why can I not place a pivot table on Sheet1 anymore?  Any ideas?  When I try to create one manually it says: "the data source you are trying to connect to is managed by an organization.  If you would like to reference it, please save your workbook in a location that is also managed."

I do use the data source tbl_pivot in a different workbook?  Does this mean that I need to name them uniquely? tbl_pivot1  2  3 ?


Sub CreateTop10PivotSheet()
    
    Sheets.Add.Name = "Sheet1"
    Sheets("Sheet1").Activate

     ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
         Range("tbl_pivot"), Version:=xlPivotTableVersion12).CreatePivotTable _
         TableDestination:="Sheet1!R3C1", TableName:="PivotTable1", DefaultVersion _
         :=xlPivotTableVersion12



    Range("A5").Select

Open in new window

Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
RWayneH

8/22/2022 - Mon
SOLUTION
Rartemass

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
RWayneH

ASKER
True that, all sheet tabs have been renamed, (even the new Sheet1 gets renamed) so used to create a new Sheet1 every time.
SOLUTION
byundt

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
RWayneH

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
RWayneH

ASKER
Thanks.
Your help has saved me hundreds of hours of internet surfing.
fblack61