Opening large Workbooks in excel

Question

Every time one of those workbooks needs to be opened, a macro I use that opens numerous huge files at various times gets stuck in the opening file dialogue box. I can fix this by clicking cancel each time; nothing will break and they'll open as intended, but I don't want to have to. Can I do anything to resolve this?

Please let me know if I need to screenshot anything. When I execute the code to open the workbook alone, it functions as intended, but when I run the complete macro, the workbook won't open (at least not in a reasonable time).

Answer 1

Here is a code I tried to open a workbook and got the data:

Sub Open_Large_WB_ReadOnly()
    
    Dim WB As Workbook
    Dim WBdir As String
    Dim Start As Long
    
    Start = Timer
    
    WBdir = "C:... some very large workbook ... .xlsx"
    
    Set WB = Workbooks.Open(WBdir)
    Debug.Print WB.Sheets(1).Range("A1").Value
    WB.Close (False)
    
    Debug.Print " Regular " & Format(Timer - Start, "0.000")
    
End Sub

Timer total = Regular 38.066 -> 38 seconds is a long time.