Insert sheet template loses page setup (2010)

[Clif McIrvin]

Am I missing a setting?

In xl2003 when I did a right-click on a sheet tab and inserted a sheet
template (.xlt) the template brought in it's page setup settings -
margins, zoom, etc.

Now, in xl2010, the margins (at least) are getting changed. I just
opened one of the .xlt files, verified the formatting and saved in .xltx
format. Unfortunately, the insert sheet process still modifies the
margins. (If it matters, the workbook is in .xlsb format.)

Suggestions?

 

[James Ravenswood]

Am I missing a setting?

In xl2003 when I did a right-click on a sheet tab and inserted a sheet
template (.xlt) the template brought in it's page setup settings -
margins, zoom, etc.

Now, in xl2010, the margins (at least) are getting changed.  I just
opened one of the .xlt files, verified the formatting and saved in .xltx
format. Unfortunately, the insert sheet process still modifies the
margins. (If it matters, the workbook is in .xlsb format.)

Suggestions?

Rather than Insert, try Copy the tab

 

[Clif McIrvin]

Am I missing a setting?

In xl2003 when I did a right-click on a sheet tab and inserted a sheet
template (.xlt) the template brought in it's page setup settings -
margins, zoom, etc.

Now, in xl2010, the margins (at least) are getting changed. I just
opened one of the .xlt files, verified the formatting and saved in
.xltx
format. Unfortunately, the insert sheet process still modifies the
margins. (If it matters, the workbook is in .xlsb format.)

Suggestions?

Rather than Insert, try Copy the tab

--------------
You mean open a new workbook from the template, then copy from one to
the other?

Nope ... same result. (That is, the margins are right when I open the
template as a new workbook, but after I move the tab the margins have
changed. Doesn't matter if I Move or Copy.)

Thanks for the suggestion.