Problem hyperlink on a form with Excel

GonzaloMG 

It seems that the upgrade from Excel 2016 to Excel 2021 has caused some issues with the hyperlinks to files in OneDrive. To troubleshoot and resolve the problem, you can try the following steps:

1. Check the file location: Verify that the file you are linking to in OneDrive is in the correct location and accessible to all users who need to access it. Ensure that the file is stored in a shared folder and that the necessary permissions are set.
2. Update the hyperlink addresses: Open the Excel file with the hyperlinks in Excel 2021. Edit each hyperlink and update the address to the correct URL format for OneDrive. Instead of using the local file system path (C:\users\myname\onedrive\Documents\myfile.xlsx), use the correct OneDrive URL (https://d.docs.live.net/0e3cdf9c7ddb146b/Documents/myfile.xlsx). To ensure the hyperlinks work correctly, you can try the following steps:

Open the Excel file in Excel 2021.

Select the cell or text where you want to insert the hyperlink.

Right-click on the selected cell or text and choose "Hyperlink" from the context menu. Alternatively, you can use the Insert Hyperlink button on the ribbon.

In the "Insert Hyperlink" dialog box, choose "Existing File or Web Page" on the left side.

In the "Address" field, enter the full URL of the file in OneDrive, starting with "https://d.docs.live.net/". For example: https://d.docs.live.net/0e3cdf9c7ddb146b/Documents/myfile.xlsx

Click the "OK" button to create the hyperlink.

Ensure that the URL you enter in the "Address" field is the correct URL to the file in OneDrive. You can copy the URL from the OneDrive web interface by navigating to the file, right-clicking on it, and selecting "Copy link" or a similar option.

By following these steps, you should be able to create hyperlinks in Excel 2021 that correctly link to files stored in OneDrive.

1. Test the hyperlinks: After updating the hyperlinks, save the Excel file and test the hyperlinks by clicking on them. Ensure that they open the correct files in OneDrive without any errors. If any hyperlinks still do not work as expected, double-check the file location and permissions.
2. Re-create the hyperlinks if necessary: If the hyperlinks still do not work after updating them, try deleting the existing hyperlinks and recreating them from scratch in Excel 2021. This ensures that the hyperlinks are set up correctly using the new version of Excel.
3. Check for software updates: Ensure that you have the latest updates and patches installed for Excel 2021. Microsoft often releases updates to address issues and improve compatibility, so keeping your software up to date can help resolve any known issues.