Re: Anyone have success accessing an Excel file th...

dplachinski · ‎Oct 08, 2020

I can add the link without issue. When I try to access the url (excel) sheet, I get two warning messages saying that Excel cannot find the file, then it opens it in read only mode.

dplachinski · ‎Oct 08, 2020

I should mention, I have tried a hyperlink of a MS Power Point, MS Word, and a JPEG. All work fine. The issue seems to only exist with Excel.

Mahesh_Sharma · ‎Oct 08, 2020

@dplachinski

This warning looks to be from MIcrosoft Excel side... when searching for this message found number of articles from Microsoft couple of them are

https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_365hp/sorry-we-couldnt-find-xxx-is-it-possible-it-was/430fc2c1-8014-492b-8dbb-4c0f9e06cfda

https://techcommunity.microsoft.com/t5/microsoft-teams/sorry-we-couldn-t-find-c-xxx-is-it-possible-it-was-moved-renamed/m-p/1505946

dplachinski · ‎Oct 08, 2020

Thanks for the response.

I read those articles as well. However, there are eluding to the path of the file being too long. As you can see from the error image, my file is located in C:\temp. Therefore, that can not be the issue. This still doesn't explain why the excel file eventually opens up in "read only" mode.

MartinHanak · ‎Oct 09, 2020

@dplachinski wrote:

Thanks for the response.

I read those articles as well. However, there are eluding to the path of the file being too long. As you can see from the error image, my file is located in C:\temp. Therefore, that can not be the issue. This still doesn't explain why the excel file eventually opens up in "read only" mode.

Hi,

I can reproduce your problem. I suggest you to open Case at PTC Support and discuss the problem with them.

Workaround:

I followed information from https://stackoverflow.com/questions/31472397/open-excel-file-through-normal-html-link page:

a.] I created E:\tmp\x.html file

<html>
    <head />
    <body>
        <a href="file:///E:/tmp/my_excel.xlsx">Click</a>
    <body>
 <html>

b.] I created E:\tmp\my_excel.xlsx file

c.] I created hyperlink in a 3D Note ... file:///E:/tmp/x.html

d.] now after 3 mouse clicks I can see Excel window showing my file

Note: I had to remove windows_browser_type chromium_browser option from my config.pro.

Martin Hanák

dplachinski · ‎Oct 09, 2020

Thanks for the response.

I have opened up case 15580742. However, I thought the community would give me an answer much quicker than support. It is easy for them to point the issue to Microsoft and not look into it any further.

dplachinski · ‎Oct 09, 2020

Thanks. That seems to be a great work around. I can open the Excel file and edit it.

Lets hope PTC support will come up with a fix.

Anyone have success accessing an Excel file that is a hyperlink in a 3D Note?

Anyone have success accessing an Excel file that is a hyperlink in a 3D Note?