OneDrive File Issues

Link Excel Table Image Names to OneDrive Files

Olivia MillerOlivia Miller Nov 18, 2026 868 views

Question details

Create clickable links from image file names in an Excel table to matching files in a OneDrive folder.

Link Excel Table Image Names to OneDrive Files
Product
Microsoft Excel and OneDrive
Device & OS
not provided
Scenario
An Excel table contains image names that match files stored in a OneDrive folder.
Observed behavior
Each image name should open its corresponding OneDrive file when clicked.
Before you start

Check that the table names match the OneDrive file names, including extensions. Identify a direct folder URL ending in a slash and confirm that intended recipients can access the files.

Solution 1Recommended

Create a calculated hyperlink column in Excel

Use this formula when the files share a direct OneDrive folder path and their names match the table entries.

A OneDrive sharing link containing a token or query string is not necessarily a direct folder path and may not work when a file name is appended. Test the resulting URL before filling the column.

1
Add a link column

In the Excel table, add a column next to the image-name column and give it a heading such as Image Link.

2
Enter the formula

In the first data cell of the new column, enter =HYPERLINK("https://yourcompany-my.sharepoint.com/personal/user/Documents/Images/"&[@ImageName],[@ImageName]). Replace the example URL with your direct folder path and ImageName with your actual table column name.

3
Fill and test the links

Press Enter and check that Excel fills the calculated column. If it does not, copy the formula down, then click several links to verify that they open the correct files.

4
Check access

In OneDrive, select a file and use Share or Manage access to confirm that the intended recipients have permission to open it.

Create a calculated hyperlink column in Excel
Check special characters: Spaces and other special characters may need URL encoding. If a generated link fails, compare it with a working direct file URL and check the file name and extension.
WPS Office

Create OneDrive image links in WPS Spreadsheets

Use the HYPERLINK function in WPS Spreadsheets to combine a direct OneDrive folder path with image names, then fill the formula down your worksheet.

  1. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 2. Enter a hyperlink formula: If the first image name is in A2, select an empty cell in row 2 and enter =HYPERLINK("https://yourcompany-my.sharepoint.com/personal/user/Documents/Images/"&A2,A2), replacing the example path with your direct folder URL.
  3. 3. Fill the formula down: Drag the formula cell's fill handle down alongside the remaining image names.
  4. 4. Test and save: Click the generated links to verify the paths and permissions, then use File > Save As to save the workbook in XLSX format.
Create clickable links to matching OneDrive image filesOpen and edit Microsoft Excel XLSX and XLS filesUse familiar spreadsheet formulas and a convenient worksheet interfaceWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't my OneDrive folder sharing link work in the formula?

A sharing link may contain a token or query string rather than a direct folder path. Test a direct file URL, or use OneDrive's Share > Copy link for each file instead of appending names to the sharing link.

Do the image names need file extensions?

Yes. The names used in the formula should match the actual OneDrive file names, including extensions such as .jpg or .png.

Does creating a hyperlink give other people access to the image?

No. In OneDrive, use Share or Manage access to give recipients the appropriate permission. They may also need to sign in.

What should I check if a generated link opens the wrong page?

Check the folder path, trailing slash, file name, and extension. If the name contains spaces or special characters, compare the generated URL with a working direct file URL and check whether URL encoding is needed.