Ticket #30755
Question
I have a report that will run to HTML but will not ever finish when I try sending to EXCEL. This report could have 20,000 plus rows. I have changed the max rows and it works fine with HTML but just spins when trying to create excel. Any thoughts you might have ? Thanks
Answer
One thing I'd like you to try to use the optimized Excel output -- it renders MUCH faster than standard Excel. To do this please change the outfmt code on your prompt page for Excel to 15.
Asked on October 30, 2020