View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Anna_Stephanie Anna_Stephanie is offline
external usenet poster
 
Posts: 3
Default CSV File Will Not Open Directly in Excel 2003

We have a CSV file that we receive as an email attachment. I am using
Excel 2003 with SP3 and the unblock file types registry changes
applied. When I double-click on the CSV file attachment to open it in
Excel 2003, I receive an error message of, "This file is not in a
recognizable format...." . I have checked the regional options and the
list separator is selected as a comma. I have checked Windows Explorer
and the CSV file format is set to open in Excel. I am using a Low
Macro security setting in Excel 2003. If I open Excel 2003 and then
open this file and run through the import file wizard, I am able to
view the file. Users are complaining that that is too many steps to
have to follow to view the file contents.

The strange thing is that I am able to directly open this file
attachment using Excel 2007.

Any assistance is greatly appreciated.