Hello, I have a macro-enabled file here that for some reason is opening very very slowly and I do not know why. I don't really have a lot going on with this, I am importing two text files when prompted that contain a small amount of data, removing the files afterwards, ejecting a usb drive. This all happens to update a chart. With how little there is going on, I just cannot figure out why it is taking so long to open, and by that I mean 30-60 seconds. I have used it now for over a year and it didn't start out this way. Any help would be great!
Excel 2010 Macro Enabled File Opens Slowly
- Thread starter Nu2Java
- Start date
Chihiro
Excel Ninja
Well... you have 1289 named ranges...
Some with #REF error.
I haven't looked too deep in your code, but you should add some routine to remove unnecessary named ranges. Most of them overlap, and I assume these are added by code somewhere.
Same goes for your workbook connections. There's 1293 connections present in the workbook.
EDIT: Tested by removing all named ranges and connections from the workbook. Took about second or two to open the file.
Some with #REF error.
I haven't looked too deep in your code, but you should add some routine to remove unnecessary named ranges. Most of them overlap, and I assume these are added by code somewhere.
Same goes for your workbook connections. There's 1293 connections present in the workbook.
EDIT: Tested by removing all named ranges and connections from the workbook. Took about second or two to open the file.
Last edited:
@Chihiro can you tell me a little more about that? 1293 connections? And what all named ranges? Thanks EDIT: I figured it out, I never knew I was saving all of those. I will lookup a VBA way of removing those after each use. Thanks again, this works awesome now.
Last edited:
@vletm thanks for your help.
Yes, in my code I am adding those. I got it working.... thanks for your help this is great!