when trying to add a row field to a pivot table I'm receiving an error message indicating "too many records to complete this operation. The pivot is not that large (results only a few hundred rows...any idea why this is happening and how to fix it?
The data is being pulled from an Access Query.
Proprietary info so I cannot attach the file...sorry.
Windows Explorer lets you open cabinet (cab) files like any other folder.
In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
Enter Foreign and Special Characters
Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~
Use these codes in any Windows application! ... whether it is a Micr…