I think Excel can handle only 256 columns.
In my opinion, a report with more than 10 columns is not user-friendly anymore.
If you have more, you are just creating data dumps. Better export to CSV in that case.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP