View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.links
John Calder John Calder is offline
external usenet poster
 
Posts: 176
Default Linking CSV file

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