MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Use of workbook as Template

Posted by philipjsmith on January 29, 2002 11:06 AM

Can anyone tell me why if I save a workbook as .xlt & then open it, put data in & save the new file it always suggests the old name as a .xls but with a "one" tagged on the old name. What happens the next time - & the next - & the next?

e.g template is records.xlt
then first record is records1.xls
& next is records1.xls again etc.

Thanks ( 2nd post - sorry for error )

Posted by Fortinbras on January 29, 2002 4:41 PM

It works the same way as the default Excel spreadsheet.(nt)