2021 home and student 2021

[jfig313]

Using excel home inventory template. On my image links I get ”Cannot open the specified file” then when I do a edit link I get “ Links are good on main drive and not on saved external drive

[#2]

@jfig313 

To resolve this issue, you can try the following steps:

1. Ensure the external drive is connected:

• Make sure the external drive containing the images is connected to your computer.

1. Update the file paths:
   • Open the Home Inventory template in Excel.
   • Look for the cells or columns where the file paths for the images are stored. It could be a specific column dedicated to the image links.
   • Check if the file paths are pointing to the correct location on the external drive.
   • If the file paths are incorrect, update them by modifying the cell contents to reflect the correct path on the external drive.

• Save the changes.

1. Verify the image links:
   • Go to the Edit Links option in Excel to verify that the links are pointing to the correct file paths on the external drive.
   • Open the Edit Links dialog by going to the Data tab in the Excel ribbon, selecting "Edit Links" in the Connections group.
   • In the Edit Links dialog, check if the file paths are correct for the images on the external drive.
   • If the links are incorrect, select the link and click on the "Change Source" button to update the file path.
   • Navigate to the correct location on the external drive and select the image file.
   • Repeat this process for any other incorrect links.
   • Click on "Update Values" to update the links with the corrected file paths.

• Close the Edit Links dialog.

After performing these steps, the image links should be updated to the correct file paths on the external drive, and you should no longer encounter the "Cannot open the specified file" error. Remember to save your changes in the Home Inventory template.

If the issue persists, it may be helpful to reach out to the template provider for more specific guidance related to the Home Inventory template in Excel. Or insert the file (without sensitive data). Additional information’s like, Operating system, storage medium, Excel version would be of additional advantage. Since no one has answered it for at least 1 day, I entered your question in various AI. The text and the steps are the result of various AI's put together.

My answers are voluntary and without guarantee!

Hope this will help you.

[#3]

Thanks for your reply. I've tried again without success. I'll try to get in touch with the template provider which came with the the program. Thanks again.