Mike Thoreson
New Member
- Joined
- Jun 16, 2023
- Messages
- 5
- Office Version
- 365
- Platform
- Windows
Hi - I'm using Forms for Excel to collect data on a project, and part of the data includes uploading attachments through the form. This process is working properly, as I've been able to upload attachments, I can see the files in another folder, and I see what looks like hyperlinks in the spreadsheet to those files. However, when I initially hover over the hyperlinks in the spreadsheet they are not active and don't open the files. I have found that if I double click on the cell with the hyperlink it goes into editing mode; then if I click out of the cell and go back to it now the hyperlink is active and it works like it's supposed to. How do I get the hyperlink to work correctly as soon as I click on it the first time around?
For situational awareness, when this project goes live there will be other people reviewing the data and I need them to be able to open the attachments from the spreadsheet without having to search through different folders or go through the double click process described above.
For situational awareness, when this project goes live there will be other people reviewing the data and I need them to be able to open the attachments from the spreadsheet without having to search through different folders or go through the double click process described above.