I have a com object that an ASP page calls. It takes an sql statement and creates a temp excel file that the browser is pointed to for download. Works great and fast, but I had selected type xls so some of our users who still have win 3.1 could still use. One of my win NT users is trying to sort the excel by a date field and excel will not change the format of the column to allow this (comes down as 01-Jan-98). Tried from excel to file save as type 5 or 7 with no results. tried format change and then caluculate. The only way I can get the excel to update the format is one cell at a time.

I have already changed the com object to download type xl5 and everything works fine, if I have to I can add another selection from the asp page, but I was wondering if I am Missing something simple.


TIA
Jeff