MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Default Workbook Template

Posted by Kris Lyon on July 26, 2001 3:18 PM

I've created a new template to distribute to my workgroup and want to make it the default when creating a new workbook. Where is that setting?

Posted by Russell on July 26, 2001 3:26 PM

One thing you can do is to have them save it in their xlstart folder as Book.xls

There are probably other ways also....

Hope this helps,


Posted by Richard S on July 26, 2001 3:28 PM

Tools|Options General Tab, select alternate startup file location. All users in workgroup have the same, and put your template there.

Posted by Kris Lyon on July 26, 2001 3:38 PM

Thanks! - that worked