Insert sheet template loses page setup (2010)

  • Thread starter Thread starter Clif McIrvin
  • Start date Start date
C

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?
 
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?
Click to expand...


Rather than Insert, try Copy the tab
 
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?
Click to expand...


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.
 
Back
Top