How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9658
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

I have an Excel spreadsheet w/ embedded pictures. When I email

Customer Question

I have an Excel spreadsheet w/ embedded pictures. When I email the spreadsheet as an attachment, the recipient does not get the pictures. She is running Office 2007. I have tried every Excel format, but she still does not get pictures. I’m running Office 2010 and when I email it to myself the pictures don’t come through until I click on Enable Editing. She says she does not have this option. Any solutions?
Submitted: 2 years ago.
Category: Microsoft Office
Expert:  John D replied 2 years ago.

Hi,

 

This could happen if the pictures are not actually embedded in the workbook but have been inserted as links. Please send me the file so I can check it and give you the right solution.

 

To send the file go to http://www.wikisend.com/ and upload the file using the Browse button (no need to signup) then copy the "File ID" number (or the download link) that you will be given and paste it here in your reply.

 

If the file has sensitive information let me know before you upload it

 

Customer: replied 2 years ago.
File has been uploaded
Expert:  John D replied 2 years ago.

Where is the Download Link or File ID (please refer to the instructions in bold)

 

 

Customer: replied 2 years ago.

Attachment: 2012-08-03_161602_2012_0801_product_sheet_heb_copy.xlsx

http://www.justanswer.com/UploadFile.aspx?FT=IU&field_name=src&MSG=RTE&FID=3

Not sure what you men by "File ID"
Expert:  John D replied 2 years ago.

File ID is what you will get when you go to www.wikisend.com , but its ok I got the file

 

Ok I checked the file and as expected some pictures have not been loaded to excel as embedded images but have been inserted as "links"

 

You need to remove the problem pictures and insert them back as real images and save the file. Then when you send the saved file the recipients will be able to see all the pictures in the file

 

If you need help in inserting pictures as embedded objects please feel free to get back to me citing your Excel version, otherwise than you for rating the answer so I can get credit for helping

 

 

Customer: replied 2 years ago.
WE use a macro to - what I thought was - embed the images. How did you determine the images were linked. I use Illustrator a lot and can easily tell the difference, but I don't know the how to determine this in Ex cel?
Expert:  John D replied 2 years ago.

Ok I will show you can tell by creating a similar file and sending it back. In the meantime please go ahead and rate the answer. Thank you

 

John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9658
Experience: Bachelor of Science - Engineering Consultant
John D and 11 other Microsoft Office Specialists are ready to help you
Expert:  John D replied 2 years ago.

Thanks

 

Ok first can you close all excel files then re-open the Excel file in question and go to sheet 'Necklaces' and tell me what do you see in cell A3

 

 

Customer: replied 2 years ago.
a3 does not have a value - but their is a picture over A3 - I cannot determine if it is embedded or linked
Expert:  John D replied 2 years ago.

What I wanted to know is if you are seeing a real picture over cell A3 or some other generic shape

 

 

Customer: replied 2 years ago.
YES - there is a picture - I think the issue is in the past the macro was run in Excel 2003 and the person who ran the macro this time runs 2007. Could this be it? I'm testing by logging into a PC w/ 2003 and emailing to sheet to my wife's email account.
Expert:  John D replied 2 years ago.

Nothing to do with the macro. That specific image over A3 is NOT embedded. It is just a link to an image stored in your computer which only you can see. When you send the file to 3rd parties they will see a broken shape icon because they do not have access to the source image that is in your computer

 

To verify this close all Excel files then go to the image itself when it is stored in your computer and temporarily delete it. Then open that excel file and go to that sheet and see if you can still see that picture

 

(make sure you then go back to the image folder immediately after testing and do UNDELETE to restore the image so you do not permanently lose it)

 

 

 

 

 

 

Customer: replied 2 years ago.
Thanks -
I deleted the image file and the picture remained in the doc. to verify, I ran the macro again and it did not pull a pic. Now what?
Expert:  John D replied 2 years ago.

I don't know what the macro does as I do not have it in that file, but as said most of your images are linked and need to be loaded as images into your file so that can be transported with the file

 

Here is what I and all other recipients see when they open your file on their systems

 

Attachments are only available to registered users.

Register Here

Attachments are only available to registered users.

Register Here

Attachments are only available to registered users.

Register Here
View Full Image

Attachments are only available to registered users.

Register Here

 

 

To correct the problem you must delete each bad link, and use the Insert tab on the Ribbon then click Picture and navigate the picture and load it that way

 

Hope this helps

 

 

Customer: replied 2 years ago.
Can I send you the macro? There are 1000's of pic's that we populate this way - generally we send out as a PDF - but the customer wants it in Excel.
Expert:  John D replied 2 years ago.

Ok I will try to review your macro and see if I can spot any issues but I will not be able to test it as it most likely deals with files on another computer with a different folder structure than that of my system, and also modifying a macro is really a different issue. But go ahead and send it and I will check it for you

 

 

 

 

 

 

JustAnswer in the News:

 
 
 
Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.
 
 
 

What Customers are Saying:

 
 
 
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
  • My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
  • Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
  • This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
  • Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
  • I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
  • Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
  • Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
 
 
 

Meet The Experts:

 
 
 
  • jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
< Last | Next >
  • http://ww2.justanswer.com/uploads/JS/jstinehelfer/2012-6-6_215146_Pictureofme1.64x64.png jstinehelfer's Avatar

    jstinehelfer

    Information Systems Manager

    Satisfied Customers:

    36
    A+ Comptia Certified computer repair
  • http://ww2.justanswer.com/uploads/JA/JasonJames122/2011-12-16_135647_jasonjamesheadshotweb.64x64.jpg JasonJames122's Avatar

    JasonJames122

    Computer Enthusiast

    Satisfied Customers:

    0
    I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business
  • http://ww2.justanswer.com/uploads/JE/jessmagz/2012-6-6_18129_jm.64x64.jpg Jess M.'s Avatar

    Jess M.

    Computer Support Specialist

    Satisfied Customers:

    301
    Computer Software Specialist for more than 10 years
  • http://ww2.justanswer.com/uploads/CH/chutz747/2011-11-6_14231_me.64x64.jpg The-PC-Guy's Avatar

    The-PC-Guy

    Computer Manager

    Satisfied Customers:

    274
    20 years experience providing remote computer support
  • http://ww2.justanswer.com/uploads/SP/spherrod/2012-6-6_174244_1000852.64x64.JPG Steve Herrod's Avatar

    Steve Herrod

    Computer Support Specialist

    Satisfied Customers:

    125
    Trained in Microsoft Office from 2000 through to latest version 2010.
  • http://ww2.justanswer.com/uploads/SE/Seashore2011/2011-12-6_33418_111205223015.64x64.jpg Chris L.'s Avatar

    Chris L.

    Support Specialist

    Satisfied Customers:

    124
    Certified Expert with over 10 years experience.
  • http://ww2.justanswer.com/uploads/KR/krkljatorm/2012-6-24_153417_ITMiro.64x64.jpg IT Miro's Avatar

    IT Miro

    Computer Scientist

    Satisfied Customers:

    97
    Bachelor's Degree in Information Technology, Microsoft Certified Professional
 
 
 

Related Microsoft Office Questions