-1

Does anyone know of a way to embed a PDF, JPG, Word file, or Outlook email into an Excel cell?

I am entering data into cells and want to link them to specific documents and to save them getting lost.

  • Are you asking if you can attach word docs, .eml etc in excel such that you send the excel file and everything stays on it for whoever receives it? – Raystafarian Mar 5 '15 at 18:09
  • yes you have hit it on the nail.. i enter lots of data but with each entry want to put a document against it, and all saved in one file no matter how big the file.. so its easy to find related documentation – Stephen Nott Mar 5 '15 at 18:11
  • And why are you using excel, as opposed to sharepoint or another kms? – Raystafarian Mar 5 '15 at 18:11
  • 1
    okay well to cut a long story short. I am a trainee accountant. using excel for accounting. what i am trying to achieve is for my clients to put some basic info into a spreadsheet, just date, description, and category and prices with and without vat, and then beside it a copy of the invoice dragged and dropped, so that they can send me by email or usb one file with everything linked together this is only for small firms who may send two hundred or less entries each time by email or usb.. so the actual files will not get too big and what i had hoped click on cell and file would open – Stephen Nott Mar 5 '15 at 18:21
  • 1
    A note on vocabulary: "embed" means to make a copy of one file and insert it into another file. This gives you a self-contained file (think of an anthology) that can grow very large (if you embed multiple other files into it). "link" means to store the name of one file in another, like a paper with a bibliography or a web page with external links. This avoids the bloat problem, but it means that the file (containing links) is crippled if the other files aren't around. You seem to be talking about embedding. If you are talking about embedding, don't say "I ... want to link them ...". – G-Man Says 'Reinstate Monica' Mar 5 '15 at 19:29
3

Tested in excel 2007
Go to Insert -> Object -> "Create from file" tab -> browse to the file -> hit OK

Source
http://smallbusiness.chron.com/insert-attachment-excel-spreadsheet-76201.html

EDIT: The negative side to this is that anything you embed will be included in the file, thus making the excel file quite large.

| improve this answer | |
  • The questions asks ** embed into the cell** not into the worksheet. – fatih_dur Jan 10 '18 at 23:18
1

The only way to lock an embedded file in excel is to first attach the file as an object in the spreadsheet. Use "insert object" and you can either insert a file or view as an icon. THen move the object wherever you want it.

Then right click on the on the object and select format object. Make sure that "locked" is selected. excel will then display the object on the selected cell and move it as the cell is moved by inserting extra cells etc.

I use this because I have a lot of rental properties and make up a monthly statement before I fill out the schedule E's. I attach invoices to cells on the line items to which they refer.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.