View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.setup
Dave Peterson
 
Posts: n/a
Default csv file opens in a single column

I think windows assigns the application to the last program that was installed
(or registered with windows).

You may want to try re-registering the version of excel you want to be the
default for windows.

Close Excel and
Windows Start Button|Run
"c:\yourpathtoyourfavoriteversionofexcel\excel " /unregserver
then
Windows Start Button|Run
"c:\yourpathtoyourfavoriteversionofexcel\excel " /regserver

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

Pete_UK wrote:

I noticed when I upgraded from XL97 to XL2000 on my old machine (but
kept XL97 on the hard disc) that when I wanted to open .csv files by
double-clicking them it took me into XL97. I had assumed that because
there was a valid entry in the file association table when I installed
XL2000 that it did not overwrite it, but that on a new installation
there would not be any entry for .csv in the table so that would be
added and point to XL2000 as part of the instalation process.

I used to get text files with an extension of .DCL, aimed at a
specialist telephone call analysis database package. I set the PC up so
that when I double-clicked these files it would be recognised and
opened by Excel - all the data appeared in column A, and I developed
some formulae in adjacent columns which I could just copy in and down
to parse the data.

I think you probably have a similar situation with .csv files on your
rogue machine. It might be necessary to remove csv from the file
association table and then re-install Excel so that hopefully the
correct association (and action) can be set up.

Hope this helps.

Pete


--

Dave Peterson