Saving Excel Spreadsheets as PDFS with Pictures

[PDFALAN]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Hi, I have an excel template for quotations which when complete I like to save as a PDF so customers can not amend the details. I like to insert a picture of the object I am quoting for, but when I save it, the picture ends up at the bottom of the pdf. I have also tried to save it as an .xlxs and .xls in various excel formats and the same thing happens each time. I basically just want the picture to stay where it is on the spreadsheet so that when I save it as a PDF, it remains there

 

[CyberTaz]

What do you mean by "bottom of the PDF"? Is the picture on a second (or
additional) page? If so it simply means that the picture is not within the
margins you have set in Page Setup. What file format you save in will not
have any effect on the position of the image.

If that isn't what's happening please provide a more exact description of
how the sheet appears in Print layout View as well as a clearer explanation
of the outcome.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[PDFALAN]

Hi, thanks for getting back to me, this is really important that I get it right. When I open the excel template for quotations I have created, I import the picture (jpeg normally) and position it into the document and save it to my quotes file as a named PDF. When I then re-open that saved document, the image I have carefully positioned appears towards the bottom of the document? The same thing happens if I save it as an Excel worksheet. My email address is (e-mail address removed) if you can help and you want to get in touch, I can either call you or vice versa, with the screen document open. I have just moved from PC and I really love the new Imac, but this one has me flumoxed. I have tried everything

 

[CyberTaz]

Hi Alan;

I'm afraid you've done nothing but restate the same thing adding no new
information. I need to know exactly where you have "carefully positioned"
the image relative to the data & the page breaks as well as explicitly what
"towards the bottom of the document" means.

Also, this is a public newsgroup - all communication is done through the
group for the benefit of those with similar issues. Please reply here with
the requested information & as much additional detail as possible.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[PDFALAN]

I had an email directly to my address from Microsoft, who have resolved the issue for me. It was to do with where the template was being opened from. I had created my own set of templates and stored them in USER TEMPLATES. if I opened them from the sheets tab in Excel, I had the problem. If I opened them from a new folder in My Docs, no problem. It is all about where you save USER created templates to. Play safe and create your own file called templates and save them there is my advice to anybody.

 

[John McGhie]

That doesn't quite add up to me. The location of a template would make
utterly no difference to the workbook created from it or the positioning of
pictures in such a workbook.

So I don't think I believe that email.

But if you want your own templates to replace the ones on the Sheets tab,
you have to overwrite the originals.

Cheers

I had an email directly to my address from Microsoft, who have resolved the
issue for me. It was to do with where the template was being opened from. I
had created my own set of templates and stored them in USER TEMPLATES. if I
opened them from the sheets tab in Excel, I had the problem. If I opened them
from a new folder in My Docs, no problem. It is all about where you save USER
created templates to. Play safe and create your own file called templates and
save them there is my advice to anybody.

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]

 

[CyberTaz]

Hi John;

My reaction was similar but went more along the lines of "WTF????" ;-)

There's absolutely no conceivable correlation whatsoever between a PDF & the
storage location of a template that was used to produce the file from which
the PDF was generated.

It's also quite curious that anyone from MS would initiate direct email
contact without posting here to that effect... Especially having not joined
the online conversation & without seeing the file first hand.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[PDFALAN]

Well what cai say? It made no sense to me either. As far as I was concerned the problem shouldn't have existed in one scenario and not the other so when you say you don't believe the email I can tell you that it did work so it seems she was right. It worked, what else can I tell you?

 

[John McGhie]

I think the step we're missing is that you changed the sheet after creating
it.

1) You created a sheet by clicking a sample in the Sheets tab

2) You made some changes to put your information on it.

3) You saved the sheet you created.

4) Next time you wanted one, you went back to the Sheets tab.

That would have given you a "blank" default sheet without your changes.

Instead, you should have created the new one by copying the sheet you saved
in Step 3. That will not be available on the Sheets tab unless you
explicitly put it there.

Cheers

Well what cai say? It made no sense to me either. As far as I was concerned
the problem shouldn't have existed in one scenario and not the other so when
you say you don't believe the email I can tell you that it did work so it
seems she was right. It worked, what else can I tell you?

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]