I've run into a problem with filtering. I'm reading in an existing Excel 2003 file, inserting some columns in several sheets, then saving the file back as an Excel 2003 file. I do create named ranges for the column insert. The problem is that in the saved file all of the sheets show Filter Mode in the Excel status bar. The only fix within Excel is to click Autofilter to turn on a filter, then click it again to turn it off (note that it did not initially show as being on). This problem exists on sheets I don't even modify.
I've found that by looping through the worksheets collection and calling ws.autofilter.showall it does resolve the problem, but I shouldn't have to do this. I'm not doing any filtering or validation in my code, and the original workbook has no filtering.
I'm using cells 4.8.2.4.
Rick