@NickzNickz
In Excel Online, it's not possible to directly link to and open attachments from a local folder on your computer. Excel Online operates within a web browser and does not have access to files stored locally on your computer due to security restrictions.
However, you can upload the attachment to a cloud storage service, such as OneDrive, Google Drive, or Dropbox, and then create a link to the attachment stored in the cloud. This link can then be inserted into your Excel Online workbook to allow users to access the attachment.
Here's how you can do it using OneDrive as an example:
1. Upload the Attachment to OneDrive:
- Sign in to your OneDrive account.
- Upload the attachment file to a folder in your OneDrive storage.
2. Get the Shareable Link:
- Right-click on the uploaded attachment file in OneDrive.
- Select "Share" from the context menu.
- In the sharing options, make sure the file is set to "Anyone with the link can view" (or adjust the sharing settings as needed).
- Copy the shareable link provided.
3. Insert the Link in Excel Online:
- Open your Excel Online workbook.
- Select the cell where you want to insert the link.
- Click on the "Insert" tab in the ribbon.
- Choose "Link" from the options.
- Paste the copied shareable link into the address field and click "OK."
4. Test the Link:
- Save the changes to your Excel Online workbook.
- Click on the inserted link to test it and make sure it opens the attachment in OneDrive.
By uploading the attachment to a cloud storage service and inserting the shareable link into your Excel Online workbook, you can provide users with access to the attachment while working in Excel Online. The text was created with the help of AI.
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
