Share via

My format changes when i open a workbook on another computer

Anonymous
2012-09-07T20:38:30+00:00

I created a workbook with 12 sheets (I used Office 2007 - Excel 2007 and Windows Vista). All the sheets are formated, some with text, calculations and so on. On the computer I created that workbook (PC) everything works fine, looks good on the screen and the printout is perfect. Whenever I copy and use that workbook on other computers (they use Office 2007, Excel 2007 and Windows Vista or Windows 7) it looks like I lose somehow the format. Cells with text won't show all the text and does not print out the sheet the way its supposed to. I have print areas in that sheet but the print out in other computers is completly different. How do I make sure that my workbook looks and prints out the same way on other computers (PC desktop and laptops) as it does on my PC desktop. Page setup is ok. The other computers have different sceen resolutions and different printers.

Thank you in advance for your help.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2012-09-08T01:39:34+00:00

    Hello,

    the different printers and their respective printer drivers are the most probable cause for the different appearance. Excel's screen rendering is dependent on the capacities of the installed default printer. Worksheets can look different on different computers, because not all printers are the same, for example cannot print as close to the paper edge as the other printer, so that will reflect in the page breaks.

    If you need to print a file on a different computer without having to edit it first, consider saving it as a PDF and sending the PDF to the other computer.

    cheers, teylyn

    Was this answer helpful?

    10 people found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2012-09-08T19:07:46+00:00

    Hello,

    the different printers and their respective printer drivers are the most probable cause for the different appearance. Excel's screen rendering is dependent on the capacities of the installed default printer. Worksheets can look different on different computers, because not all printers are the same, for example cannot print as close to the paper edge as the other printer, so that will reflect in the page breaks.

    If you need to print a file on a different computer without having to edit it first, consider saving it as a PDF and sending the PDF to the other computer.

    cheers, teylyn

    I opened the workbook on my wifes computer, same printer, same software as on my computer, differend screen, different resolution and i have the same problem. Cells width is not correct and the cell hight is also not correct. This workbook is like a template for different people, they open the workbook and then safe as NAME from Customer, fill data in and after safe it and print it. Screen is not correct and print out is not correct. When I set up the page on the other computer with the same margin as my computer it dosen' t help. If you have an answer I would be very thankful.

    Cheers, Rolf

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments
  2. Anonymous
    2012-09-12T07:41:10+00:00

    Verify if service pack 3 for Office 2007 is installed on the other computer.

    Do you face this issue only with this specific Excel file?

    Copy/paste the content of the file to new Excel workbook, save it in a different name and then check if it works fine.

    You may also create a new Excel file and check if it works fine.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments