Hi John,

Not really, but you could automate the opening of the csv file whenever you
open your Excel workbook. Also, it's not a good idea to mis-name the csv
file's extension. This makes no difference to how Excel processes the file,
but it's misleading, since any app capable of reading a text file (eg Notepad,
Word) can also read csv files, but not necessarily Excel (xls) files.

Cheers

--
macropod
[MVP - Microsoft Word]


"John Calder" wrote in message
...
| Hi
|
| I run W2K with Excel 2K.
|
| I have a workbook that links to a file on a server. The file on the server
| is a file that is downloaded from a mainframe in a CSV format. Also,
although
| this file is a csv format it has been setup to download with a .XLS
extension.
|
| For my workbook link to this file to work correctly, I have to open up the
| csv file and save it as an true Excel file. If I do not do this then the
file
| on my computer does not automatically update the links.
|
| Is there anyway I can have my links to automatically update correctly
| without having to save the csv file as an Excel file?
|
| Any help is much appreciated.
|
| John