Page set up change it self

  • Thread starter Thread starter shiro
  • Start date Start date
S

shiro

Hi all,
Why does my worksheet's page setup change after
i create a copy on another workbook.On the origin
workbook,the data is fit at scale 65% on A4 paper.
But in the new workbook it can be fitted on scale
59% only.Why?
 
Hi,

I'm not sure how you are copying your data, but if you are NOT copying the
entire workbook, you would need to set everything exactly as the original,
including margins, etc.

Also, I have run into this before if the printer driver used on the original
machine is a different version than the one used on the destination, this can
cause your issue. Apparently, it is the printer driver that decides what will
fit on a page. I discovered this once when our IT department updated the
drivers on some of my user's computers, but not mine.

HTH
 
You must log in or register to reply here.

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

Similar Threads

Userform to Select what worksheets to print 1
Macro for printing 2
How to reference a cell from anther workbook without opening it 0
PrintArea Query 2
Setting page layout and print set up in code for a new worksheet 2
Find a value in a sheet and replace it with another value if it matches 8
Printout or Print Preview right side of contents truncated 5
Import multiple workbooks to current workbook in specified row number 0

Back
Top