maximum number of worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to create approx. 200 worksheets in one workbook. Is there a
limit to the number of worksheets that a workbook will hold? Is there a quick
method to copy my master spreadsheet to 200 other worksheets?

My master spreadheet is an annual budget for a commercial property. I am
setting up budgets for 200 properties. When dealing with this many
properties/worksheets is it more advisable to set up the budget template to
repeat itself in one worksheet which may require approx. 15,000 rows or is
the method noted above (create 200 worksheets with approx 75 rows/worksheet)
the better method? This is a big job so I thought I would try to get some
advise before I start. Thanks for your suggestions.
 
Hi Shooter

can't advise what is the best method as i don't work with workbooks or
worksheets of the size you are talking about, but if you decide to create a
200 sheet workbook then this (IMHO) is probably the easiest way to do it.

Choose tools / options / general - change "sheets in a new workbook" to 200
click OK
open a new workbook - it will now have 200 sheets
Choose tools / options / general - change "sheets in a new workbook" back to
3 click OK
set up the first sheet like you want all of the others
right mouse click on the sheet tab and choose "all sheets"
select the whole of the first sheet (ctrl & A - twice if it doesn't select
everything the first time)
choose edit / fill across worksheets - ALL
click on cell A1
right mouse click on the sheet tab and choose Ungroup Sheets

your sheets should all now be set up for you.

Cheers
julieD
 
Hi
number of sheets depends mostly on your memory.
Normally it is better to use a database data layout on one SINGLE
sheet. That is use the property name as one column and add the other
data in the respective columns. This way you can use Excel's filter,,
sort, pivot table functions
 
It is limited by memory, look in help for specifications
Having said that I wouldn't want to do a beast like this. I would use
multiple workbooks

Regards,

Peo Sjoblom
 
I have been trying to put all my data in one work sheet and then extract the
data to another worksheet but I think it is going to be pretty hard for me
 
The new outbreak of an Extraordinary Help designed by experts in MS Excel.
write to : (e-mail address removed)
 

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

Custom Headers 1
Sum of different value in different worksheet & cell number 2
Formula works on all worksheets except for 2 3
combining data from multiple worksheets into one 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Adding values from a different worksheet 2
combine multiple spreadsheets into one workbook 1
transfering cell values progressively through worksheets 8

Back
Top