troubleshooting Question

FTP forces download of Excel 2007 files.

Avatar of chrisdodds
chrisdodds asked on
Windows XPMicrosoft ExcelServer Software
4 Comments1 Solution1412 ViewsLast Modified:
I have an end user that is trying to view/edit excel spread sheets from an FTP server.  However when he connects and clicks on the Excel spreadsheet, he is given the option to "Open" or "Save".  When he chooses to "Open" the file, the window immediately pops up and asks him if he'd like to save the file and at the bottom he is given this error:  

"The file you are downloading cannot be opened by the default program.  It is either corrupted or it has an incorrect file type.  As a security precaution, it is recommended that you cancel the download.  How can I decide what software to open?"

The "How can I decide what software to open?" is a link to the Internet Explorer help files but I find nothing very helpful about it in this situation.  With that said, I know the file is not corrupted and I know it's not our company firewall blocking the connections because I'm able to download all the files from that ftp site onto his PC and open them that way without any probelm - so I know it's not because he's got an earlier version of Excel, etc.   Also on this FTP site are PDF files.  He is able to open them without any problems.  It seems to be more of a microsoft office problem at this point.

I can login to the FTP server on a different PC using the same credentials, and open this Excel file without being forced to save.  Does anybody have any idea what setting needs to be modified to allow for my enduser to access the Excel spreadsheet file without having to save it first?

I've attached a screen shot of what happens when the end user selects a file from the FTP site.  Hopefully this clarifies my issue.  HELP!!!

Error received when attempting to open an Excel 2007 file on my FTP server.
One last bit of info...  My user CAN open .xls spreadsheets and work on them, but is NOT able to open and work on .xlsx spreadsheets without first being forced to save the file....  It must be an Excel 2007 thing?  And when using CoreFTP I am able to configure my enduser to access the FTP file server and from within that program I can edit .xlsx files without having to save to the local PC, but not natively in Windows XP.  It may have something to do with the Temporary Files download location for Excel 2007 spreadsheets?  These are the properties on my Excel (.xls) filetype - but my Excel 2007 9.xlsx) filetype is set up the same way.  I'm so frustrated...

 Excel filetype settings
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 4 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros