Pivot table custom sort causes Excel to crash after upgrading to Excel 64 bit

Hi,

I just recently received a new laptop from my IT Service Desk and it came installed with Excel 2016 32 bit. I subsequently requested Excel 2016 64 bit to be installed as that is what I have used in the past. Excel 2016 MSO (16.0.4549.10000) 64 bit is the version that got installed. We are eventually migrating to Excel 365, but that won't be until the end of this calendar year.

Now whenever I attempt to refresh a pivot table from within my VBA code, Excel abruptly exits with no error messages provided. I previously had a laptop with Excel 2016 64 bit (I don't know what version it was) and the following code worked perfectly:

Please Login or Register  to view this content.

Any suggestions why this could be happening?

I thank you for any help!

Hi,
To his credit, a colleague split the string array into substrings using the SPLIT() function before running the custom sort. I don't quite understand why, but his solution seems to work in both 32 and 64-bit Excel.

Thanks for looking at this.