Running a simple xlookup formula and for some reason, it's bogging my system...
5950x
128gb RAM
Excel 64bit
Win11
1TB NVME
Restarted program, everything is up to date.
At first, I was referencing cells in a separate work book. Migrated the information i needed into the same WB. Same problems.
I had to configure excel to only use 16 threads instead of the 32 because it was erroring out stating there were no resources available. I'm at a loss.