You cannot change the Paper Size in Excel when using the Macintosh Remote Desktop Client (RDC) with a redirected printer. The Paper Size option may be disabled or may not do anything when selected. This occurs when you use the "Use a printer that is connected to the Mac" option in RDC Preferences and connect to a Windows Terminal Server to run Windows Excel from the Terminal Server.
This is a limitation in the design of the Macintosh Remote Desktop Client. The Macintosh Remote Desktop Client supports printer redirection with minimal functionality. It does not support the full features of a printer which are required for Excel to determine what paper size is available from the printer.
- Switch to a printer that is located on the Terminal Server, change the paper size and then change the printer back to the redirected printer.
- Turn off the "Use a printer that is connected to the Mac" option in RDC Preferences. Instead of the redirected printer use a printer driver located on the Terminal Server. Note: the administrator may be able to map printer drivers to networked printers if the infrastructure is available.
This limitation will also cause a run-time error in VBA code that changes the PageSetup.PaperSize property.
Article ID: 2772563 - Last Review: Oct 17, 2012 - Revision: 1
Microsoft Excel 2013, Microsoft Excel 2010, Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Remote Desktop Connection Client for Mac 2