maximum number of spreadsheets in one workbook
have a workbook with 500 spreadsheets. Have one template and using
CTRL-SHIFT to copy template to new spreadsheets. Worked good till yesterday.
Now CTRL-SHIFT kicks me out with error message every time. Can "insert' new
sheets and 'copy-paste' template.
1. Am I at the 'limit' of sheets in this work book?
2. What is max number of sheets per work book?
3. Why has CTRL-SHIFT failed now?
4. Is there a 'faster-easier' way to create blank templates? Need 1,000 or
so.
Thanks!
|