PraveshG81
New member
- Joined
- Oct 6, 2011
- Messages
- 22
- Reaction score
- 0
- Points
- 0
Hello,
I need some help carrying over hyperlink from one sheet to another. I basically use an internal program to export data to my raw tab. One of of the fields that I export is the "Acquisition Agreement". This field brings in the hyperlink to get to a document stored in our internal document management service (for security purposes i have removed the DMS link and put links to yahoo or google). On the Results tab I am using a Offset/Match formula to bring in columns from the Raw tab.
I need help with Column B (Acquisition Agreement) in the Results tab. As you can tell from the attached spreadsheet i have add a hyperlink component to my formula BUT when i go and click on any cell that has content in Column B I get the following error: (Cannot open the specified file). However, when i go to the same link in the Raw tab it works.
Could someone please tell me how i can fix this issue?
Thanks!
Pravesh
I need some help carrying over hyperlink from one sheet to another. I basically use an internal program to export data to my raw tab. One of of the fields that I export is the "Acquisition Agreement". This field brings in the hyperlink to get to a document stored in our internal document management service (for security purposes i have removed the DMS link and put links to yahoo or google). On the Results tab I am using a Offset/Match formula to bring in columns from the Raw tab.
I need help with Column B (Acquisition Agreement) in the Results tab. As you can tell from the attached spreadsheet i have add a hyperlink component to my formula BUT when i go and click on any cell that has content in Column B I get the following error: (Cannot open the specified file). However, when i go to the same link in the Raw tab it works.
Could someone please tell me how i can fix this issue?
Thanks!
Pravesh