Default "fit to one page" scaling for all excel sheets

[summetg]

Hi guys,

I needed to set something up on Excel 2010 where we can default all Excel sheets to scale to one page. The user does not want to have to click this option every time. Is there anyway to default it?

[shg]

Create a workbook with that setting and save as a template named Book.xltx in the XLSTART folder.

[summetg]

I probably didn't mention this, but these sheets are being created by SQL's report writer. Will that fix work and where is the XLSTART folder located?