Nick,
Sorry, but I never heard of Excel templates, and I don't have time at the moment to google it. So some general remarks.
1. If this workbook is made by an third-party application program, read the manual of that application to see what it can and what it can't do with respect to formatting the spreadsheet it produces. That doesn't seem to be an Excel problem.
2. If you're doing the same everyday record (or write if necessary) a macro, put it in your personal (or workgroup) macro spreadsheet and use it to format the unformatted spreadsheet from the application program exactly as you like/need it.
Hope this helps.
Kees
Not sure if Im pointing in the correct direction or not, but Ill try.
We have an online appointment system at work that allows truckers to make appointments to bring loads to us.
This is a new appointment system. We have to option of printing it out the way they want it printed, which isnt very useful to us. OR we have a chance to send it to Excel.
My question is, can I use a prebuilt template to send this information to.
The way we are viewing it now, theres no grid lines or anything and we have to fill in quite a bit of information, so we have to sit down and draw gridlines every day.
Im faurly comfortable with Excel but havent used the template function at all.
Would building a template retain cell formatting etc?
Thanks
Nick

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic