How many worksheets can you have in any one excel document I understand a spreadsheet can have 1048576 rows and 16384 columns does this mean total rows for all worksheets in the one document?

Answer 1

Those numbers are for each worksheet. You can have as many worksheets in an Excel 2007 workbook as the memory in your computer will allow. Excel 2003 and earlier are limited to 255 worksheets per workbook.