Calculate *without* updating external links

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

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'
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DDE Links 2
VBA to run all variable combinations in a calculation model and store result 6
A troubling issue with external links update and workboon_open macro 1
External Link to workbook 1
running speed 7
Easy one... 13
Open external book before updating links? 1
How to update all links before re-calculation for macro? 1

Back
Top