Microsoft Office 365 – Excel – Hyperlink Command

Question

When using a hyperlink command to access information in another spreadsheet that resides in the same folder as the calling spreadsheet, the following warning is shown all the time in one folder, but not if these two files exist in another folder (same drive, same level and access, just different folder name).

This is the hyperlink command:

=HYPERLINK("[Second File.xlsx] 'Sheet2'!A1","Go to Second File Sheet2 Cell A1")

This is the warning:

  

When answering “Yes,” “Second File.xlsx” is opened to Sheet2, Column A, Cell 1.

The next annoyance occurs when clicking X to return to the calling file. 

Even when no changes of any kind have been made to “Second File.xlsx” the following message is displayed:

Clicking “Save” or “Don’t Save” does return you to the calling file.

Answer 1

Good morning Sushma,

1. This behavior occurs in many directories. In each of these directories, there are 2 .xlsx files. One of these files is the same in all directories (copies) and this file is being hyperlinked to from the other file in the directory. That .xlsx file has different content but the same structure (this is the file that initiates the hyperlinks) in each directory.

It would be helpful if I could send you the 2 files involved. If you could email me at ******@gmail.com (0-that's a zero) I will send you the files (stripped down, so you won't have to look at unrelated data and formulas. 

2. Don't know. I usually use the "built-in" hyperlink command, which works fine at all times, but cannot be used here as I need to hyperlink to different workbooks in that first file.
3. No.

Thanks for your help.

5/28/2016 - Still same problem.

It appears that Excel thinks that some files, in some directories, are "unsafe."  But these same files, copied to other directories, are considered by Excel to be perfectly safe.

I don't know if the problem is the file or the directory it resides in.

I can easily provide examples, but Sushma has not continued his/her participation in this issue.

Answer 2

Hi,

Thank you for posting your query in Microsoft Office Community.

I need more information before we proceed.

1. Does the issue happens in one particular file or in all Excel file with hyperlinks?

• 2. Are you able to open hyperlinks from other Office applications?
• 3. Is this computer connected to a domain/ network?
• I look forward to your reply to assist you further.

Thank you.