How can I set up Excel 97 to automatically convert/open .csv files

J

Jean-Luc240660

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

Dave Peterson

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Openig CSV file format with Excel in Office 2007 1
Convert csv to Excel files 1
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Excel CSV Files; Creating Of 3
Converted xlsx file to xls. New xls file isn't right, try to correct, fails compat checker 0
Run-time error ‘13’ mismatch type 1
Convert a csv to xls prior to import 2
Automatically join files 3

Top