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
 
Back
Top