carloExcel
New Member
- Joined
- Feb 9, 2022
- Messages
- 2
- Office Version
- 365
- Platform
- Windows
When I create a pivot table from a dataset of 600000 Rows It appears this error message. What does it exactly means?
What are the causes of this message?
The pivot table I want to create has 5 row fields, 2 filter fields and 2 calculated fields.
Set PCache = master.PivotCaches.Create(SourceType:=xlDatabase, SourceData:=PRange.Address(1, 1, x1A1, External:= True))
Set PTable= PCache.CreatePivotTable(TableDestination:=PSheet.Cells(2, 2), TableName:=pivotTableName)
On google I could not find any answer.
I will be happy for any answer