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

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
>