Number of wsheets in an excel workbook???

  • Thread starter Thread starter mariasa
  • Start date Start date
M

mariasa

hey guys, how many wsheets does one excel workbook have? I need to have
about 66 - is that possible?

Thanks.
Maria
 
Yes

I have created a workbook with more sheets in it that that. obviously
depending on the amount of data on each sheet your workbook could be
getting quite large and possibly unmanageable! I guess you will have to
try it! Depending what you wish to do it is often easier to have all the
data on one sheet and sort or lookup or filter to get what you require
rather than having to reference seperate sheets, but the choice is
yours!

Regards

Dav
 
mariasa said:
hey guys, how many wsheets does one excel workbook have? I need to have
about 66 - is that possible?

Thanks.
Maria
Click to expand...
The most is 256.
OverAC
 
The actual number depends on how much available memory you have.
 
You must log in or register to reply here.

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

Similar Threads

before save event 2
vlookallsheets across workbooks 9
Use of Cell Values Instead of Hard Coding 6
using activeworkbook.worksheets 6
VBA Question 6
excel worksheet protection with exceptions 1
autofit in multiple workbooks 3
Data from 3 wsheets into billing invoice wsheet 3

Back
Top