ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)
-   -   How can I set up Excel 97 to automatically convert/open .csv files (https://www.excelbanter.com/setting-up-configuration-excel/238113-how-can-i-set-up-excel-97-automatically-convert-open-csv-files.html)

Jean-Luc240660

How can I set up Excel 97 to automatically convert/open .csv files
 
How can I set up Excel 97 to automatically convert/open .csv files in xls
format without having to use conversion each time ?

Dave Peterson

How can I set up Excel 97 to automatically convert/open .csv files
 
I haven't used xl97 in a longggggg time, so this is a guess.

Try reregistering excel.

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets some of the windows registry to
excel's factory defaults.

And if I recall correctly, .csv files should be opened in excel by default.

One more question...

If you're not using an English version of excel, then maybe the default
extension for comma separated values isn't .CSV????

Do you see that as an option in the the File|SaveAs dialog?

Jean-Luc240660 wrote:

How can I set up Excel 97 to automatically convert/open .csv files in xls
format without having to use conversion each time ?


--

Dave Peterson


All times are GMT +1. The time now is 01:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com