T trip_to_tokyo Dec 4, 2009 #2 In EXCEL 2007, according to MS documentation:- "Limited by available memory (default is 3 sheets)" Please hit Yes if my comments have helped. Thanks.
In EXCEL 2007, according to MS documentation:- "Limited by available memory (default is 3 sheets)" Please hit Yes if my comments have helped. Thanks.
D Dave Peterson Dec 4, 2009 #3 Limited by your pc's memory. How many worksheets a workbook may have? Click to expand...
J Jim Thomlinson Dec 4, 2009 #6 While the number of sheets you can have is limited only by memory, the number of sheets that you should have is limited by practicallity. I will guarantee you that you will hit your practical limit long before you hit the memory limit.
While the number of sheets you can have is limited only by memory, the number of sheets that you should have is limited by practicallity. I will guarantee you that you will hit your practical limit long before you hit the memory limit.
G Gord Dibben Dec 4, 2009 #7 One more note.................... The maximum number of default sheets for a new workbook is 255 You can add more after the workbook is open............depending upon memory as others have pointed out. Gord Dibben MS Excel MVP
One more note.................... The maximum number of default sheets for a new workbook is 255 You can add more after the workbook is open............depending upon memory as others have pointed out. Gord Dibben MS Excel MVP