Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problems with incorrect linked values
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup returning multiple (incorrect) values | Excel Discussion (Misc queries) | |||
Incorrect values on pivot chart???help!!! | Charts and Charting in Excel | |||
X axis displays incorrect values | Charts and Charting in Excel | |||
lookup returning incorrect cell values | Excel Worksheet Functions | |||
Incorrect SUM Values in Excel Spreadsheets | Excel Worksheet Functions |