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
SergeiBaklan
Sep 27, 2021Diamond Contributor
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
- alpademSep 30, 2021Copper ContributorThank you so much sir. I did not know that.
- SergeiBaklanOct 01, 2021Diamond Contributor
alpadem , glad to help