Picture Links don't reliably print in Excel 2007

[AmyB123]

Hi,

Here's the problem: I have tried creating picture links on a new worksheet in the book by Copy-->Paste as Picture Link, and also by using the camera tool. After only a few pictures, I check the Print Preview and find that only some pictures show in the print preview. Other times, no pictures show in the print preview ( I end up looking at a single blank page for print preview, although the document contains a few pages of pictures.

I am using Excel 2007. I created the XL07 workbook by copying some sheets from an Excel 2003 workbook, but I don't think that's the root of the problem, as they were only data worksheets. All the pictures have the property set to print, and I also have show all selected under Options.

Furthermore, if I print the document to PDF, the PDF is blank, but a ghost image of the pictures can be seen with Ctrl+A (Select All)

Please help! I don't understand why sometimes some pictures show, while other times, other pictures show instead. The picture link in 2003 has been reliable for me, but I need to use Excel 2007 because of the larger worksheet size.

Sincerely,

Amy

 

[xlhelp]

Have you used Page Layout View inder View tab to see if you can see the pictures.

If you can see them, check that there isn`t a print area selected.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents

 

[AmyB123]

Hi,

Thanks for the input. I already set the print area to include the pictures, and they do show in the page layout view. The problem is that they don't print, nor do they appear in print preview. It's even weirder, since sometimes some pictures show, and sometimes the same pictures don't show.

Amy

 

[xlhelp]

Make sure you have the latest service pack installed. There was a problem with printing in the first release of 2007.

Canadian eh! Check out the new social forum Tek-Tips in Canada.
With the state of the world today, monkeys should get grossly insulted when humans claim to be their decendents