Problems with incorrect linked values

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

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
 
The copying of dates and loosing the formating is not associated with the
updating of the links. You are probably using copy and then Pastespecial to
copy the formula. PasteSpecial only copies one type at a time like : Value,
Format, Formula. You need to use PasteSpeical twice. First Paste the value.
the use PasteSpecial a 2nd time and paste the format.
 
Joel,

Actually, I just copied the original worksheet containing the
formulas. So, is your advice still the same?

Alan
 
Copy the sheets using pastespecial twice should solve the problem. Select
all the cels and cpoy the selected cells. don't use the copy method on the
tabs at the bottom ov the worksheets. If youare using VBA then use

sheets("Sheet1").cells.copy
 
Joel,
I update some of the formulas, and then I get prompted to
"Update Values". How do I avoid this?

Thanks, Alan
 
Back
Top