Forum Discussion
alpadem
Sep 27, 2021Copper Contributor
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.
- Sep 27, 2021
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
NikolinoDE
Sep 27, 2021Platinum Contributor
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.
alpadem
Sep 30, 2021Copper Contributor
Thank you.