Calculate *without* updating external links
Myabe you could try one of those two settings:
'Workbook.UpdateLinks' setting or 'Workbook.UpdateRemoteReferences = False'
"Stuart" wrote:
Friends...
This may be a trivial question, but i can't seem to find an answer to
it:
Is it possible to calculate a model (or application, or sheet etc) but
to NOT update any external links?
I have a consolidation model that i want to force to calculate during
some code, but every time i do, it updates the external links (or
tries to)... and i get a lovely cascade of #REF! errors.
Stuart
|