HELP! Excel workbook appears fine for all others, will not show photos for me!

Occasional Reader

 

  • I am running a Macbook Air (13in Early 2015) Monterey Ver 12.7.4
  • Microsoft Excel for Mac, ver 16.84
  • This is a file that I am working supplied by the client by an outside party (from airtasker in Australia).  I have supplied links to  both files, just in case some does not want to run macros.  I have included what I see to help.  Is there a way to tell how a picture is added? 
  • Because what I am doing is reliant in seeing the photos, that are no longer available, I really need to figure out how to get them back? If possible... I also have an error that came up when I tried to paste the sheet.  I have read that doing it in a microsoft account, may cause issues, with other versions?
  • I am hoping someone has magic to figuring this out as I am under the gun to do several things to this spreadsheet and cannot start until I can see! 
  • Just one sheet with no macros 
  • Full workbook with personal data removed - Macros 
  • THANK YOU in advance~
  • Screen Shot 2024-06-04 at 11.45.38 AM.png
  • Screen Shot 2024-06-03 at 9.15.42 PM.png
1 Reply

@SharonJones 

It sounds like you are dealing with an Excel file where images are not displaying correctly on your Mac, while they do appear for others. This issue could be related to various factors, such as Excel settings, file compatibility, or the way images were inserted into the file. Here are some steps you can take to troubleshoot and hopefully resolve the issue:

1. Check Image Display Settings

Make sure Excel is set to display images properly:

  1. Open Excel.
  2. Go to Preferences (Excel > Preferences in the menu bar).
  3. Under the View section, ensure that "Show picture placeholders" is not checked.

2. Test on Another Machine

Open the file on another Mac or PC to see if the issue is specific to your machine. This will help identify if it's a machine-specific problem or something within the file.

3. Verify Image Links

If the images were inserted as links, verify that the links are not broken:

  1. Open the file in Excel.
  2. Go to the Data tab.
  3. Click on Edit Links.
  4. Check if the links to the images are intact and not broken.

4. Copy and Paste Special

Sometimes copying and pasting the images using a different method can help:

  1. Open the file in Excel.
  2. Select an image.
  3. Right-click and choose Copy.
  4. Go to a new location (or a new workbook), right-click, and choose Paste Special > Picture.

5. Save As a New File

Saving the workbook as a new file can sometimes resolve display issues:

  1. Open the file in Excel.
  2. Go to File > Save As.
  3. Save the file with a new name and see if the images appear in the new file.

6. Check for Compatibility Issues

Ensure the file is compatible with your version of Excel:

  1. Open the file in Excel.
  2. Go to File > Check Compatibility.
  3. Resolve any issues that are found.

7. Check for Excel Updates

Make sure your version of Excel is up to date:

  1. Open Excel.
  2. Go to Help > Check for Updates.
  3. Follow the prompts to update if there are any available.

8. Reinsert the Images

As a last resort, if you have access to the original images, you might need to reinsert them:

  1. Open the file in Excel.
  2. Go to the Insert tab.
  3. Click on Pictures and reinsert the images manually.

9. Inspect the File in VBA Editor (If Applicable)

If the file contains macros that manage the images, check the VBA code:

  1. Open the file in Excel.
  2. Press Alt + F11 to open the VBA Editor.
  3. Inspect the code for any references to image handling.

10. Use a Different User Account

Try opening the file under a different user account on your Mac to rule out user-specific settings:

  1. Create a new user account on your Mac.
  2. Log into the new account and open Excel.
  3. Open the file to see if the images display correctly.

 

NOTE: My knowledge of this topic is limited, but since no one has answered it for at least one day or more, I entered your question in various AI. The text and the steps are the result of various AI's put together. Maybe it will help you further in your project, if not please just ignore it.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.