JonElCanche
Board Regular
- Joined
- Aug 25, 2011
- Messages
- 59
I have a XLSM file that I made that take around 45 seconds to 1 min to open and I am not sure why or how I could speed things up.
The file is 6 MB, uses 4 different custom user forms running some code, and has 12 tabs that have two columns of array formulas each down to row 5000.
I figured since the array formulas did not extend indefinetly that they wouldn't slow things down too much.
Saving the file does not take too long, 20-30 seconds.
Any thoughts on this?
The file is 6 MB, uses 4 different custom user forms running some code, and has 12 tabs that have two columns of array formulas each down to row 5000.
I figured since the array formulas did not extend indefinetly that they wouldn't slow things down too much.
Saving the file does not take too long, 20-30 seconds.
Any thoughts on this?