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


Select the file in Windows Explore, SHIFT-Right-click on the File and choose
Open With and select Excel...

Are you able to open the file?

The only reason I can think of is that while saving another extension is
getting tagged on to the file name like filename.csv.txt though if it is in
text format it should open in the text editor...


"Anna_Stephanie" wrote:

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.