In Excel 2007, when User A creates a new workbook, there is only 1 worksheet for the book. When user B creates a new workbook, there is the standard 3 worksheets for the book. How do I get this back to default for User A?
The workbook being opened has more than 50 worksheets that have been in the file for the last year. When User B opens the file, all 50 or more sheets are accessible. This happens with both files saved as 2003 files because the workbook has VBA macros in it and if I open new xlsx files that are in Excel 2007 format.
Cancel the question. This was apparently a cockpit error. the workbook was sized very large when a space delimited (.prn) version of one worksheet was made. I would swear I checked this before I asked the question, but I just reduced the workbook size again and the problem went away. It is interesting that the problem migrated to all excel files for user A.
Best Answer
That's a per-user setting, with the default 3. To change it in Excel 2007, go to
Microsoft excel button (multi colored top left icon, aka "pearl") -> excel options button (bottom right) -> popular tab.in the "when creating new workbooks" section changeinclude this many sheetsto your desired number of sheets.