Excel 2007 won't print some graphics

[raehippychick]

Hi All

I’m having a very annoying problem with Excel 2007 not printing some graphics in a Balanced Scorecard

The ‘normal’ un-interfered with graphics on a sheet will print fine, but the ones that I made ‘magically appear’ just won’t print or show in print preview

I have 3 traffic lights graphics on a sheet called Graphics and depending on the RAG status of a project in the sheet called ProjectPlans the relevant coloured traffic light picture shows in the front page of the scorecard. This is all looks fine on the screen but won’t cooperate at all when it comes to printing

Anyone got any ideas please? Or has anyone had a similar issue?

I can’t post the workbook as it is full of sensitive info, including named ranges having sensitive info

Very many thanks in advance

Rae

[DonkeyOte]

If the graphics are objects is the Print Object set to true (ie checked) ?

[raehippychick]

Yep, the graphics all have print object checked

But looking at it the ones that won't print are picturse and the ones that will seem to be shapes

[martindwilson]

make up a sheet with the 3 examples in same format with pretend info and post

[romperstomper]

Could you explain exactly how the "magical appearance" works, as it appears to be related?

[raehippychick]

Attached a cleaned up copy

One other thing I notices was that ordinary graphics I had on the scorecard, some of them printed ok and some came out blacked out, I had to remove them though as they were sensitive too

Rae