Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add csv to Open "All Excel Files" (XL2007)
When you click on the Office Button in Excel 2007 and then click on Open, the
default dialog box is "Open All Excel Files." Excel will automatically open ..csv files, but .csv files are not among those that are displayed by default for selection. You have to go down to the lower right corner and change "All Excel Files" to "All Files (*.*)" in order to see .csv files that can be selected for opening. Is there some way to add .csv files to the list of files that are included in "All Excel Files"? It's strange that ".html" and ".htm" files are listed under "All Excel Files" (when most of them would open as gibberish), and ".csv" files are not included. Thanks. -- Jim (a.k.a. ORTNPALMS) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add csv to Open "All Excel Files" (XL2007)
hi, Jim !
AFAIK, *.csv files are included in 2007 as file type: - text files hth, hector. __ OP __ When you click on the Office Button in Excel 2007 and then click on Open the default dialog box is "Open All Excel Files." Excel will automatically open .csv files, but .csv files are not among those that are displayed by default for selection. You have to go down to the lower right corner and change "All Excel Files" to "All Files (*.*)" in order to see .csv files that can be selected for opening. Is there some way to add .csv files to the list of files that are included in "All Excel Files"? It's strange that ".html" and ".htm" files are listed under "All Excel Files" (when most of them would open as gibberish), and ".csv" files are not included. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add csv to Open "All Excel Files" (XL2007)
I don't think that we are talking about the same thing. When you click on
Open, the default is "All Excel Files" and a list of such files is presented in parentheses. The list is (*.xl; *.slsx; *.xlsm; *.xlsb; *.xlam; *.xltx; *.xltm; *.xls; *.xlt; *.htm; *.html; *.mht; *.mhtl; *.xml; *.xla; *.xhv; *.odc; *.uxdc;). Neither .csv nor ".txt" is in that list and neither text nor .csv files are displayed in the active folder window from which you select a file to open. You have to go down and change "All Excel Files" to "All Files (*.*)" in order to open a .csv file. My question again is, is there a way to add ".csv" to the list of "All Excel Files" so that you do not have to switch to "All Files" in order to see .csv files that can be opened? Thanks. -- Jim (a.k.a. ORTNPALMS) "Héctor Miguel" wrote: hi, Jim ! AFAIK, *.csv files are included in 2007 as file type: - text files hth, hector. __ OP __ When you click on the Office Button in Excel 2007 and then click on Open the default dialog box is "Open All Excel Files." Excel will automatically open .csv files, but .csv files are not among those that are displayed by default for selection. You have to go down to the lower right corner and change "All Excel Files" to "All Files (*.*)" in order to see .csv files that can be selected for opening. Is there some way to add .csv files to the list of files that are included in "All Excel Files"? It's strange that ".html" and ".htm" files are listed under "All Excel Files" (when most of them would open as gibberish), and ".csv" files are not included. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Add csv to Open "All Excel Files" (XL2007)
I don't think you can get them to appear at the same time.
Cliff Edwards |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
change the file open default permanently to "All files" | Excel Discussion (Misc queries) | |||
modify how files are displyed in the "file open" window | Excel Discussion (Misc queries) | |||
I get "Access Denied" trying to open network files. | Excel Discussion (Misc queries) | |||
On opening Excel, 4 non ".xls" files open that I cannot delete | Excel Discussion (Misc queries) |