Calculate *without* updating external links
 

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

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