Forum Discussion

ADGToreUp's avatar
ADGToreUp
Brass Contributor
Jul 25, 2022
Solved

Slow Loading .xlsb File

Good morning everyone, I have a 2.5mb .xlsb file that takes approximately five minutes to load.  It is only one sheet, but has some VBA in the background.  It is a tracker, and I have entered in a l...
excel
Macros and VBA
JKPieterse's avatar
JKPieterse
Silver Contributor
Jul 26, 2022
Maybe a (hidden) range name with an external link? Those can slow down the opening considerably.
  • ADGToreUp's avatar
    ADGToreUp
    Brass Contributor
    Jul 26, 2022
    Where would I check for this? I suppose it is possible that I added something by mistake, but the code I pasted above is the only VBA used in the workbook. I checked connections and do not see any.
    • JKPieterse's avatar
      JKPieterse
      Silver Contributor
      Jul 27, 2022
      ADGToreUp You can take my word for it. You should check for this as in my experience (broken) links hidden away in range names can cause precisely what you describe: a slowdown of loading your file.
      • ADGToreUp's avatar
        ADGToreUp
        Brass Contributor
        Jul 27, 2022
        I ended up fixing it by copying everything over to another Excel file and then adding the code in. I believe you were correct though, somewhere hidden there was a link to another document.