Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV File Will Not Open Directly in Excel 2003
Close Excel first and On the Windows Taskbar
1) StartRun "excel.exe /unregserver"(no quotes)OK. 2) StartRun "excel.exe /regserver"(no quotes)OK. See the space between exe and /regserver You might have to designate a full path to 2003 excel.exe. In that case StartRun "C:\yourpath\excel.exe" /regserver(quotes required)OK. If no joy with that, post back and we can propose another fix. Gord Dibben MS Excel MVP On Tue, 10 Mar 2009 11:34:58 -0700 (PDT), 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV File Will Not Open Directly in Excel 2003
Hello,
I tried that and that did not work. Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
CSV File Will Not Open Directly in Excel 2003
Tried what?
Are you responding to me or Sheeloo? Gord On Tue, 10 Mar 2009 12:54:28 -0700 (PDT), Anna_Stephanie wrote: Hello, I tried that and that did not work. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot open excel file directly | Excel Discussion (Misc queries) | |||
file excel cannot open directly | Excel Discussion (Misc queries) | |||
Cannot open the Excel file in the desktop directly | Excel Discussion (Misc queries) | |||
Any way to open an excel file directly to a worksheet? | Excel Discussion (Misc queries) | |||
Why I cannot open the excel file directly? | Excel Discussion (Misc queries) |