How can I get excel to accept larger workbooks

F

Frustrated

I am currently using Quatro-Pro to create workbooks. It will accept at least
500 worksheets per workbook. Since Excel is set to 256 worksheets per
workbook, I can't transfer my current work to Excel. How can I increase the
size of Excel workbooks?
 
J

Jim Thomlinson

There is no limit on worksheets in a workbook The only limit is available
memory...

If you run this code it will happily create 300 worksheets

Sub test()
Dim lng As Long
For lng = 1 To 300
ThisWorkbook.Worksheets.Add
Next lng
End Sub

To find out about memory limits check out this link...
http://www.decisionmodels.com/memlimits.htm
 
G

Gord Dibben

Excel is not set to 256 sheets per workbook.

255 sheets is the upper limit for number of default sheets in a new
workbook.

You can add more once the workbook is opened.

Limit above 255 depends upon the resources available to you.
'

Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top