I have the same problem. I have found the only way to get the file to
display correctly is to have the source file open as well as the target file.
this is of course a major nuisance.
i have worked with Excel for many years, but I have only seen this error in
the last couple of months.

Sandy.


"Renee L at the Club" wrote:

My links in my worksheet become #value! when I insert a row/column. Help!