Results 1 to 10 of 10

How to Embed PDF file on Excel worksheet

This is a discussion on How to Embed PDF file on Excel worksheet within the Excel Questions forums, part of the Question Forums category; Hello; I have excel 2003. I want to embed couple of PDF file on one excel sheet in the way ...

  1. #1
    New Member
    Join Date
    Feb 2010
    Posts
    11

    Default How to Embed PDF file on Excel worksheet

    Hello;

    I have excel 2003. I want to embed couple of PDF file on one excel sheet in the way that if I double click on the embedded pdf file it open as PDF on separate window. I have seen that kind of excel sheet and have used in the same way. But I do not have that excel file any more otherewise I just copy the formula.

    Any help in this regard will be greatly appreciated.
    thanks

  2. #2
    ZVI
    ZVI is offline
    MrExcel MVP ZVI's Avatar
    Join Date
    Apr 2008
    Location
    Sevastopol
    Posts
    2,747

    Default Re: How to Embed PDF file on Excel worksheet

    Try menu (Excel 2003) or Ribbon (Excel2007): Insert - Object - From file (as icon)

  3. #3
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    14,146

    Default Re: How to Embed PDF file on Excel worksheet

    You can embed a pdf or other types of objects with Insert | Object. Typically in this case you'd choose "from file", browse out to your file, and then embed it. You can choose to just show an icon or the whole document in Excel.

    There is an option to "link" to the file - then the file is not really "in Excel" - rather, Excel just knows where it is. This is helpful since updates or changes to the original file are updated in Excel (such as graph data). A pdf document might be something that isn't going to change and you may not want this kind of linked object - also it won't break if files are moved.

    Using: Office 2007/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  4. #4
    New Member
    Join Date
    Feb 2010
    Posts
    11

    Default Re: How to Embed PDF file on Excel worksheet

    Guys;

    I tried many time to Inser - Object- From File with all available option.
    But I am getting an error called:

    "CAN NOT INSERT OBJECT"

    I don't know why this error is coming.

    Assistance is needed

    Thanks

  5. #5
    MrExcel MVP
    Moderator
    xenou's Avatar
    Join Date
    Mar 2007
    Location
    Clev. OH, USA
    Posts
    14,146

    Default Re: How to Embed PDF file on Excel worksheet

    Maybe, Worksheet Protection is on?
    Or, if the workbook is a Shared Workbook ... it may not work.

    Using: Office 2007/Win7 (work) Office 2010/Win7 (home)

    You are rich in proportion to the number of things you can let alone.
    -- Henry David Thoreau

  6. #6
    ZVI
    ZVI is offline
    MrExcel MVP ZVI's Avatar
    Join Date
    Apr 2008
    Location
    Sevastopol
    Posts
    2,747

    Default Re: How to Embed PDF file on Excel worksheet

    There would be some additional info in error message about wrong Class or DLL registration in case of not compatible versions of DLL were installed (overwritten).

    Example of such info:
    "Cannot insert object" in Excel
    {ac9f2f90-e877-11ce-9f68-00aa00574a4f} Class Not Registered.
    fm20.dll was unable to register itself in the system registry

    For that case you can try recommendation described in Microsoft Excel cannot insert object.
    The same issue can happen with other DLLs sounded in error message.

    Can you insert other types of files in new empty workbook’s sheet?
    Try for example to embed the Excel file as icon.
    If ok then the reason can be in PDF reader software registration, else the reinstallation of Excel is recommended.

  7. #7
    New Member
    Join Date
    Nov 2009
    Posts
    7

    Default Re: How to Embed PDF file on Excel worksheet

    Hello- just an extension of this question. Once you embed the pdf to the Excel worksheet, how can you email/share the spreadsheet with the pdf still embeded. Thanks!

  8. #8
    ZVI
    ZVI is offline
    MrExcel MVP ZVI's Avatar
    Join Date
    Apr 2008
    Location
    Sevastopol
    Posts
    2,747

    Default Re: How to Embed PDF file on Excel worksheet

    Quote Originally Posted by MickeyLisa View Post
    Hello- just an extension of this question. Once you embed the pdf to the Excel worksheet, how can you email/share the spreadsheet with the pdf still embeded. Thanks!
    Hi,

    It seems exactly the same as sending workbook without embedded document.
    For example, load file into Excel, choose menu File – Send to – Mail recipient (as attachment). I’ve found this working.
    Where you’ve stuck in this case?

    Regards
    Vladimir Zakharov
    Microsoft MVP Excel

  9. #9
    New Member
    Join Date
    Nov 2009
    Posts
    7

    Default Re: How to Embed PDF file on Excel worksheet

    I've tried to send it this way with the appropriate PDF files, but when clicking on the embedded icon on the spreadsheet it comes up as an error.

  10. #10
    New Member
    Join Date
    Mar 2014
    Posts
    1

    Default Re: How to Embed PDF file on Excel worksheet

    Quote Originally Posted by ZVI View Post
    Hi,

    It seems exactly the same as sending workbook without embedded document.
    For example, load file into Excel, choose menu File – Send to – Mail recipient (as attachment). I’ve found this working.
    Where you’ve stuck in this case?

    Regards
    Hi, I tried to do that. But still I cannot load the file I embedded. Do you have another way for this? Hoping for your immediate response. Thank you.

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com