Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    134
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Creating PDF of Excel file (Excel 2003 SP3)

    Hello all,
    I have a form created by someone other than me. Once its filled in, I have to print a PDF verions of the form, but I'm only getting 3/4 of the form in the PDF file. I'm using Adobe Acrobat 7.0.9 Professional version. Attached is a copy olf the Excel form. Has anyone encountered this problem before, and do you know how can I fix it?
    Attached Files Attached Files

  2. #2
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    134
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Creating PDF of Excel file (Excel 2003 SP3)

    Here's what I get when I PDF.
    Attached Files Attached Files

  3. #3
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Creating PDF of Excel file (Excel 2003 SP3)

    When I printed the sheet to Adobe I got pretty much the same results. However using the 2007 Addins from Microsoft when I published it to pdf it came out perfectly. I am not sure if that addin from Microsoft is available for Office 2003 but you might check.
    I would post the link, but I seem to be having a problem with the TagPanel.
    Attached Files Attached Files
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  4. #4
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    134
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Creating PDF of Excel file (Excel 2003 SP3)

    Do you mean the addin that allows you to click on the Acrobat icon in Office applications and create PDFs that way? If so, I have that addin, and it comes out the same way (3/4 of a page). If there is a different addin, could you just post the url and I'll cut and paste? Thanks!

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Creating PDF of Excel file (Excel 2003 SP3)

    Do you mean 2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS? That works with Office 2007 only, there is no version for Office 2003 or earlier.

  6. #6
    Silver Lounger t8ntlikly's Avatar
    Join Date
    Dec 2001
    Location
    Chandler, AZ
    Posts
    2,162
    Thanks
    46
    Thanked 13 Times in 11 Posts

    Re: Creating PDF of Excel file (Excel 2003 SP3)

    I sure can now that I figured out what was going on with the TagPanels: Like I said however this is for Office 2007 but you never know.
    Office 2007 Addins
    Thanks John
    Teamwork is essential; it gives the enemy other people to shoot at. (Murphy's War Laws #39)

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Creating PDF of Excel file (Excel 2003 SP3)

    To the best of my knowledge the add-in only works with Office 2007, I'm afraid. (it was, I think, originally going to be built into Office 2007 itself)
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    134
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Creating PDF of Excel file (Excel 2003 SP3)

    Thanks. I doubt we'll be upgrading to 2007 any time soon, so I'll just file that link away for future reference.

    Any other ideas what might be wrong and how to fix it? I've never had this problem with any other Excel file.

  9. #9
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating PDF of Excel file (Excel 2003 SP3)

    Hi

    I don't really use PDF documents much but what I did was go into your excel and made the page setup 60% of the original and then printed to PDF Creator which is a free program I found somewhere and I got this if it is any good to you

    Cheers

    Steve
    Attached Files Attached Files
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  10. #10
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    134
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Creating PDF of Excel file (Excel 2003 SP3)

    Thanks, Steve. I've tried reducing to 60% and that doesn't work either with Adobe. I guess maybe I'll go look for PDF Creator.

  11. #11
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    Surrey, United Kingdom
    Posts
    1,001
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating PDF of Excel file (Excel 2003 SP3)

    Hi

    Try this, it worked as well and its free (some ad screens whilst it is saving but nothing to worry about) http://www.pdf995.com/

    Cheers

    Steve
    Cheers

    Steve

    Asking the questions everbody wants the answers too but feels too stupid to ask themselves :-)

  12. #12
    2 Star Lounger
    Join Date
    Nov 2002
    Posts
    134
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Creating PDF of Excel file (Excel 2003 SP3)

    Thanks for the link! I'll head over there in a bit and check it out. I really, really don't like Adobe anyway - I'll be happy to find an alternative.

  13. #13
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating PDF of Excel file (Excel 2003 SP3)

    Just out of interest, I thought I'd have a poke around. Using Excel 2002, I'm getting the foreshortened result you get in both Adobe Acrobat and PDFCreator.

    If I copy everything to a new workbook, no problem - however I do get these two oddities (in red below). Is this something to do with it originating in Excel 2003?
    Attached Images Attached Images
    • File Type: gif x.gif (6.3 KB, 0 views)

  14. #14
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Creating PDF of Excel file (Excel 2003 SP3)

    The "oddities" are outline buttons; the outline is also present on the original sheet but it has been hidden - there's a check box for Outline Buttons on the View tab of Tools | Options...

  15. #15
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating PDF of Excel file (Excel 2003 SP3)

    Ah! Only Jan 3rd and I've already learnt something new <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Thanks!

Page 1 of 2 12 LastLast

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •