Forum Discussion
Solved
More Than 15 WorkSheets Open
As You know excel has allow to open max. 15 worksheets at the same time. Is there any possiblity to increase the number such as 30.
That's Windows limitation, not Excel. You may select in File Explorer 15 files, open them, after that select another 15, again open - till you have enough memory for all files.
To expand above limit you may add registry key as here How To Open More Than 15 Files At Once from Context Menu in Windows - NEXTOFWINDOWS.COM
In this link is a VBA code that promises to do this. Have not tested it, maybe this code will help you.
https://www.overclock.net/threads/vista-cant-open-more-then-15-files-at-one-time.440951/
additional info:
Excel specifications and limits
Hope I could help you with these information / links.
Thank you.