View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
The Dude The Dude is offline
external usenet poster
 
Posts: 14
Default 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