VBA Edit Links to Files

[Pinaceous]

Hi All,

I have a workbook that references several different workbooks.

My only question is that when I open up the parent document it takes a very long time to gather these different reference data points to update it.

My question is, How would I speed this process up?

Possible solution; Can I create a dummy document that is in continuous update mode and reference that document?

Please let me know your thoughts.

Thanks,
Pinaceous

 

[Pinaceous]

Is there a way to update the external links based upon selecting which worksheet that is selected?

For example, I can run this into a private sub:

Sub ImportWorksheet()
    ' This macro will import a file into this workbook
   
    Application.ScreenUpdating = False

    Dim ws As Worksheet
    Dim wbOpen As Workbook
   
    For Each ws In ActiveWindow.SelectedSheets
   
    Select Case ActiveSheet.Index

            Case 23 'September
                With ws
           
           
                 Application.AskToUpdateLinks = True

          
               End With

              
     End Select
    
    Next ws

Application.ScreenUpdating = True
   
End Sub