you cannot place a field that has more than 8000 items in the column area

I cannot add rows in the pivot table to show as a column data,,, it tells me “‘you cannot place a field that has more than 8000 items in the column area” . How I can make the pivot tablr accepts a larger range of rows data?  Its only two months of data only separated by time. thanks

 

here the part of the code 

 

‘Store Data into the Hidden Logs spreadsheet’

    Sheets(“Sheet1”).Select

    Sheets(“Sheet1”).Copy Before:=Workbooks(“Hidden Logs.xlsm”).Sheets(2)

    Windows(file_name).Activate

    Sheets(“Stela_” & Month(Date) & “_” & Day(Date)).Select

    Sheets(“Stela_” & Month(Date) & “_” & Day(Date)).Copy After:=Workbooks(“Hidden Logs.xlsm”).Sheets(HiddenWorksheetCount)

    Range(Cells(2, 1), Cells(last_row, last_col + 2)).Select

    Selection.Copy

    Sheets(“All”).Select

    Last_Row_in_All = Range(“A65536”).End(xlUp).Row

    Range(“A” & Last_Row_in_All + 1).Select

    ActiveSheet.Paste

    Sheets(“Hidden History”).Select

    Range(“B5”).Select

    ActiveSheet.PivotTables(“PivotTable1”).PivotCache.Refresh

    ActiveSheet.PivotTables(“PivotTable1”).PivotFields(“PRDtrim”).AutoSort _

        xlAscending, “PRDtrim”

By: Salvador Rincon

Leave a Reply

Your email address will not be published. Required fields are marked *