I have an input Excel spreadsheet I open for some processing. I
cannot control the input format, and it contains links that are from
spreadsheets that do not exist on my machine.

I do not care about these broken links, but I do not want the user
prompted about updating them. So, I set it to never update the links
in that worksheet using VBA code.

The problem, which may be related to that: I copy formulas from
another workbook. These formulas are correct, but the values are
wrong! For example, some of them may have a date of 1/1/00 instead of
the referenced cell's value (e.g., 03/31/09).

Anybody know how I get around this problem?

Thanks in advance, Alan