Embedded objects, text, pictures not visible in print preview – Microsoft Excel

Problem:

A Microsoft Office Excel 2003 user reports that after sending an .XLS spreadsheet to an Excel 2007 user or vice versa, has it modified, then sent back, some embedded or inserted text, pictures, objects, and boxes are not visible in Print Preview or when actually printing the file.  This occurs not only when printing to a printer, but also exporting to a .PDF.

The objects can be modified when in normal working mode outside of Print Preview.

Solution:

Excel 2007

-       Right-click the affected object or picture.

-       Click Size and Properties

-       Click the Properties tab

-       Check Print Object

Excel 2003

-       Right-click the affected object or picture.

-       Click Format Object

-       Check Print Object