Home

Pivot table can take a list separated by hours

herssain
Occasional Visitor

Hello Everyone, I already joined to this Forum, in my Job I inherit a VBA macro that create a Pivot table from a big list, this list is separated by date and more important by hour, then many lines the same date even the same hour cause register many events in the same hour, the macro want to create a table by months and use the entire information but appearing is more than can be handle showing a message like this : " You cannot place a field that has more than 8000 items in the column area. If you want to use this field in the report, click OK, and then move the field to either the row area or page area"
I review the main page where the code takes the info and I notice take more columns more that it needs, but way more... a lot more. I tried to change the code to fix that but I could not.
Please help. Let me know if need more details or part of the code .
Thanks

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies