We have a really strange problem here with the printers in our company. We have several users travelling often from Europe to the US and back. Their laptops are set up in the US. So all their configuration regarding the paper size is "letter". But when the users are in Europe they have only printers with A4. Since they are less then 10 users we decided to install their "Europe" drivers directly on the laptops and not distribute it over Active Directory.
Now to the problem: Our Xerox printer will not print MS Excel documents. The test page and print outs from IE or MS Word are fine. (For MS Word we needed to set a special parameter in order to change the size of the document automatically. But this feature is not available in the printer dialogue of Excel. We already tried to set the paper size of the Excel document to A4.
According to the manufacturer the printer should have a feature to automatically expand letter pages to A4. When we asked a Xerox technician why this is not working in this case then he replied that Excel is sending wrong information. It declares the document as A4 but is sending all the data (measurements) regarding the size letter.
Somehow I can not believe this. Did someone else have the same problem? The only "solution" I see is to print Excel documents first into PDF documents and then print those on the printer. But this is not really an acceptable solution.
Did anybody have a similar problem and found some "hidden" configuration parameter within Excel that could help me?
All laptops have Windows 7 and Office 2007.