Hi All,
looking for a resolution - I don't know why this is happening, but I'm using
SUMIF formulae that references external links (source data is in external
file). The correct value is retrieved when the source file is open, however,
when the workbook is closed, I get a #VALUE error. But if I open the external spreadsheet
that it is linked to, then the #VALUE error disappears and the correct value
displays.
Any ideas on what is causing this and how to fix this? I prefer not to have to have both files open to work on the linked file. Thanks Mark </pre>
looking for a resolution - I don't know why this is happening, but I'm using
SUMIF formulae that references external links (source data is in external
file). The correct value is retrieved when the source file is open, however,
when the workbook is closed, I get a #VALUE error. But if I open the external spreadsheet
that it is linked to, then the #VALUE error disappears and the correct value
displays.
Any ideas on what is causing this and how to fix this? I prefer not to have to have both files open to work on the linked file. Thanks Mark </pre>