Fix Broken Image Links in an Excel Home Inventory Template with WPS Spreadsheets
Question details
The user needs to fix image links in an Excel Home Inventory template that still point to an old external drive or folder path and fail to display.
- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Opening a home inventory workbook after images were moved to a new drive or folder, causing non-working image links.
- Observed behavior
- Images fail to open or appear blank because the workbook links still reference the old drive or folder path.
Connect the external drive or network folder that contains the original image files, and verify that the image files still exist in the expected location before updating links.
Update the linked image source in WPS Spreadsheets
Use this when the workbook opens but the linked images do not display because the source drive or folder has changed.
This method changes the external link at the workbook level, so the Home Inventory template points to the current image file or folder without replacing the images manually.
Open the Excel Home Inventory template in WPS Spreadsheets and make sure the external drive or network folder with the images is connected.
Go to the Data tab on the ribbon and click Edit Links.
In the Edit Links dialog, select the image link that shows the old drive or folder path.
Click Change Source, browse to the current image file or folder on the connected drive, and select the correct image file.
Click Update Values, close the Edit Links dialog, and save the workbook. Keep the external drive connected whenever you reopen the file.
Correct image paths directly in the worksheet
Use this when your inventory sheet stores image locations as path text or hyperlinks rather than workbook-level links.
Fix Broken Excel Image Links with WPS Office
You can repair broken image links in an Excel Home Inventory template directly in WPS Spreadsheets. Open the Data tab, use Edit Links to update the source, and save the workbook so your inventory images display from the current drive or folder.
- 1. Download and install WPS Office: Download WPS Office from the official WPS site and install it on your computer.
- 2. Open the Excel Home Inventory template: Launch WPS Spreadsheets, click Open, and select the Excel Home Inventory template file.
- 3. Open Edit Links: Click the Data tab and select Edit Links to view the workbook links.
- 4. Change the image source: Select the broken image link, click Change Source, browse to the current image file or folder, and click Update Values.
- 5. Save the workbook: Save the repaired workbook and keep the external drive connected when opening it in the future.
Frequently Asked Questions
Why do my Excel Home Inventory images still fail after moving files to a new drive?
The workbook links are usually still pointing to the old drive or folder path. Connect the correct drive, open the workbook in WPS Spreadsheets, and use Data > Edit Links > Change Source to repoint each image link to the current location.
Can WPS Spreadsheets edit Microsoft Excel workbook links?
Yes. WPS Spreadsheets is compatible with Excel workbooks and provides an Edit Links tool under the Data tab for updating external references such as linked images.
Where is the Edit Links command in WPS Spreadsheets?
Open the workbook, click the Data tab on the ribbon, and select Edit Links. If the command is inactive, the workbook may not contain external links, so check the image path cells instead.
Do I have to keep the external drive connected after fixing image links?
Yes, if the images remain linked rather than embedded. Keep the external drive or network folder connected whenever you open the workbook unless you embed the images or move them to a local folder.
Will updating image links affect my inventory data?
No. Updating a link only changes the source path to the image file. Your inventory text, numbers, and worksheet structure are not affected.
