Insert sheet template loses page setup (2010)


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?
 
Ad

Advertisements

J

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
 
Ad

Advertisements

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?


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top