Excel 2013 issue: Problems With Hyperlinks To Other Excel Files

0 votes
asked Apr 20, 2017 in MS Excel Issues by Jeeny
After making a hyperlink in reference to another excel spreadsheet, the issue arises and when I tries to click the hyperlink causes excel to get hanged for 2-3 minutes and resume with opening the linked spreadsheet. Linking to a Word document or other type, file works fine. I have searched for a solution but can’t seem to get anything that help me. Does anyone having any suggestions regarding this.

1 Answer

0 votes
answered Apr 20, 2017 by Stevens (230 points)

Your hyperlink statement is fine expect that if you want to link to K1 in sheet2 you would have: =HYPERLINK(“[PROFILE.XLSX]SHEET2!K1”, K1)   The second k1 refers to K1 in Sheet1 and the content present in that cell would appear in the cell with the hyperlink. Another, possible way is to set up your links by right clicking in the cell where you want to hyperlink.Try this, hopefully it will work for you.

Welcome to Q&A - Repair MS Excel File, where you can ask questions and receive answers from other members of the community.