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