Link to home
Start Free TrialLog in
Avatar of pepps11976
pepps11976

asked on

Print Preview Images in Excel

Can anyone tell me why i have an excel spreadsheet using Excel 2007, i have added some images to the document if i submit a print Preview none of the images show up, or if i print it the images will also not be printed.
Avatar of SiddharthRout
SiddharthRout
Flag of India image

In the PageSetup, Uncheck the "Draft Quality"

Sid
See Snapshot below.

Sid
Untitled.jpg
Also Right Click on the Image and Click on "Size and Properties". Under the properties Tab, select "Print Object"

Sid
Avatar of pepps11976
pepps11976

ASKER

Hi i have checked the settings and draft quality is unchecked
How about what I mentioned in ID: 35059326?
      
Sid
Yes i have also checked that it was also already selected
In that case May I see the file?

Sid
Ok i have just tried this from another machine and it all shows correctly i am unsure if the copy of Office that they have is ligitamate or not do you think this could be the issue.?
One should always use legitimate copy. However that might not be the cause of it.

Sid
Do u still need to see it
It wouldn't hurt to see it.

Sid
Avatar of Rory Archibald
Have you tried a different printer?
here is the spread sheet
woi.xlsx
Password?

Sid
lodge
Your Draft Quality is ticked in this document and hence you are not able to see the image. Please refer to post1 above :)

Sid
yes i think i ticked it on to see if it made a difference but it is not ticked on the real one
Here is the file with Draft Quality unchecked.

Check this file.

Sid
Updated.xlsx
I just unticked but still cannot see the image
Check the file that I attached above. Do you see the image?

Sid
i do see the image i added another image to that file set the print area to include that new image but now i have change the print area the image is missing again, i have not touched the settings that you changed

am i going mad
Upload the file again please with the new image.

Sid
same PW
Updated.xlsx
If I try to open the file, it says it is corrupt.

Sid
Here it is again if i look at this on a different machine i can see the pictures
Updated.xlsx
just out of interest on the machine having problems if i create a brand new sheet and add an image i can see that in print preview
Yes, I can see the picture in this. The file that I gave you earlier, Could you see the picture on the same pc where you are not able to see the picture in this one?

Sid
>>>just out of interest on the machine having problems if i create a brand new sheet and add an image i can see that in print preview

Then the only thing that I can think of is corruption. Your file is corrupt.

Sid
i did see a picture but the print area had changed
If you reset the print area, then are you able to see the image?

Sid
ok now i can see the picture but  the preview will show completly in the wrong area
Try a pagebreak preview. What do you see?

Sid
how do i do a page break preview in 2007?
It is under the View Tab, on the left hand side :)

Sid
Page break preview shows it correctly but print preview does not, whats all that about :)
Just noticed going back to the start when i initially add the image and it does not appear in Print Preview it is there in page break preview, then resetting the print area sort of puts the image there in print preview.
ASKER CERTIFIED SOLUTION
Avatar of SiddharthRout
SiddharthRout
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial