Header Picture in Excel, location information

[Guest]

Hi,
I have created a worksheet for use in the company. I inserted a picture as
part of the header and saved the file. After moving the file to a company
share the picture is not present when printed. I don't know where i
originally sourced the picture from or how to save the picture into the
actual worksheet. Can anyone help me either find the picture file location so
i can copy it and modify the worksheet or fix it so the picture stays in the
fgile when it is moved to another drive / share.
Thanks
Phil

 

[Guest]

Open the file that you want the picture in and click FILE in the menu and
select PAGE SETUP. In the dialog box click the HEADER/FOOTER tab and then
click the CUSTOM HEADER command button. Move your cursor to the location you
want to place the picture in (left/center/right) and then click the next to
last button on the button bar, INSERT PICTURE. Locate and select your
picture and click the INSERT command button. This embeds the file in your
header. Only one picture per section.

 

[Dave Peterson]

The picture should stay with the file.

But pictures in headers/footers was first supported in xl2002.

Is there any chance that a user opened your file in xl2k (or below) and then
saved the workbook. (I don't have xl2k to test, but I'm guessing that this
would delete the picture.)

If all the users are running xl2002+, then the picture should still be
there--unless someone removed it.

Does it show up in file|Print preview?

If yes, it's still there and maybe it's a printer problem.

=====
One way to get pictures back as separate files (if they're still in the
workbook), is to do a File|SaveAs and choose Web Page (*.htm, *.html)

You'll find a new folder named yourfilenamehere_Files with a bunch of .jpg's in
it.

If the picture doesn't show up in that folder, then it's been deleted from the
workbook.