Reset New Workbooks
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 |
Reset New Workbooks
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 |
Reset New Workbooks
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 |
All times are GMT +1. The time now is 02:30 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com