I think the real problem is that the "sending" file is a .csv file. If you save
that file as a .xls, then excel will be able to update the links.

CSV files are text only -- so there really isn't aren't columns and rows until
the file is opened in excel.



George wrote:

Hi,
I have an excel file linked to a csv file and when i open the excel file i
get prompted with "the workbook contains links that cannot be updated" and i
am asked if i wish to continue or edit links.
If I hit edit links i see a warning in the status stating that i must open
the source(the csv file). So this brings me to my question "Can i have it
update automatically without having to open the source file?
Note i have already unchecked the box in the tools/options/edit.
Thanks
George

--

Dave Peterson