When you open Excel, the first workbook you get is "Book1". If you
were to close it and then open a new workbook, you would get "Book2".
Is there a way to reset this so that it defaults back to "Book1", if
there are no othe workbooks open?

Thanks in advance

hi
excel remembers how many new books it has created per session and numbers
them accordingly. closing and reopening excel(new session) is the only way i
know to reset.

Regards
FSt1

" wrote:

When you open Excel, the first workbook you get is "Book1". If you
were to close it and then open a new workbook, you would get "Book2".
Is there a way to reset this so that it defaults back to "Book1", if
there are no othe workbooks open?

Thanks in advance

There is no way to reset Excel's internal counter.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Sat, 17 Jan 2009 09:16:29 -0800 (PST), wrote:

When you open Excel, the first workbook you get is "Book1". If you
were to close it and then open a new workbook, you would get "Book2".
Is there a way to reset this so that it defaults back to "Book1", if
there are no othe workbooks open?

Thanks in advance