Having a problem with files downloaded via IE6

I am attempting to open a generated Excel file from the "Open" button of
the IE. The excel file itself has been generated by reading an excel
template. While clicking the Open button it is opening and at the same
time it is popping up an error message saying "Cannot open Pivot Table
Source file.....".

But when I save the generated excel file using the "Save" button and
opening it from the file from the saved path it opens properly without
any error.

Through debugging and Googling around I discovered the certain versions
of IE (in this case version 6), MS Excel could not parse the Workbook
data to generate the pivot table report. This is caused by a problem witj
the "saved" filename as IE appends something like "[1]" to make it as
"fileName"+ "[1]"+ ".xls" to the original name when it saves it in the
users temporary directory. So instead of downloading "fileName.xls" IE
winds up downloading "fileName[1].xls". So when the pivot table goes to
recalculate it tries to find data in "fileName.xls" but cannot since it
was saved as "fileName[1].xls".

This really has us bugged... I also have reports that the same screwy
thing happens in IE5 but have not confirmed yet.

Anybody have any ideas on workarounds for this? Users simply want to
open the Excel spreadsheet from the website and not download/open.

Any insight would be appreciated.

Howard Johnson