update remote references

  • Thread starter Thread starter ian
  • Start date Start date
I

ian

Hi group, I was wondering is it possible to permanantly turn off the "update
remote references" option in the calculations tab of options?
or is there a way to set up each spreadsheet to disable it on startup?

hope you can help...
 
You can include the VBA code for the workbook.
Place it in the ThisWorkbook object.

Private Sub Workbook_Open()
ActiveWorkbook.UpdateRemoteReferences = False
End Sub
 
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

Word VBA to update cross-referencing 0
How do I filter master list to multiple sheets? 2
Excel question 3
Circular reference help 4
Paste link only - not value 4
Excel Cannot Complete this task 1
Changing column reference for number of formulas at once 1
Cells WON'T stop refreshing automatically 5

Back
Top