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?

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

--
HTH...

Jim Thomlinson


"Frustrated" wrote:

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?

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

On Fri, 31 Jul 2009 11:33:01 -0700, Frustrated
wrote:

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?