hi Kevin,
What do you mean by "library"?
Here are some options which should help if your "library" is jus
another workbook...
I must add the caveat for all (?) of the following options. Putting
workbook onto manual calculation provides huge potential for spreadshee
errors, because the setting is a Excel/Application level setting whic
is saved with any workbooks that are saved while calculation is manual
This means that next time the workbook (any of those saved) is opened i
may discreetly & dangerously rechange the setting to manual.
1) You should be able to turn the calculation mode to manual withi
Excel via [alt + T + O] - Formulas - Calculation Options, before openin
the file from within Excel.
2) Also within [alt + T + O] - Advanced, scroll down to "whe
calculating this workbook" & untick "update links to other docs". Scrol
further to "General" & tick "ask to update automatic links".
3) With a file open (that has links) press [alt + E + K] - [Start u
prompt...] & choose here. This probably (I haven't tested) change
exactly the same stuff as options 1 & 2.
4) Alternatively, adding the below code into the Thisworkbook modul
may help: Option Explicit
Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub
hth
Ro
