update links question

[Guest]

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]

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.

 

[Guest]

Hi.

Yes.

Note: Although the dialog box diaplays the following message:

..csv file may contains features that are not compatible with csv (Comma
Delimited). Do you want to keep the Workbook format.

Click Yes. You view the .csv file in the Excel iteself. The solution is open
the .csv file and copy and paste special -> paste link into the target file
and the updation is simultaneous when both the files are open.

However, I think it is a bug because the .csv is opened in the Excel format
and still the taget file expects you to fix the link althought the Excel can
identify the source file.

Challa Prabhu