Home

Opening an excel file protected view excel 2016 shows a values then enable it is shows #name?

Highlighted
gbowtell
Occasional Visitor

Hi

 

Problem with Excel 2016 and need a resolution.  When our users open an excel file that has been emailed to us and has external links behind the values, it shows these values but when I press the enable edit button on the protected view banner all the values turn to #name?,

 

I have turned protective mode off and its still the same.

 

Excel 2013 users have not got this problem i.e. it shows the values.  So its a problem with Excel 2016.

 

There must be a solution to this.

 

Help !

Related Conversations
Remove duplicates not working properly
Mcelli in Excel on
1 Replies
Populate summary page in Excel
Carissa_aggie in Excel on
0 Replies
Formatting Cells with Multiple Conditions
nozygatos in Excel on
1 Replies
Bonus calculation % achieved, % payout
Jennifer Lefief in Excel on
2 Replies
Pulling word data into excel
amandamy in Excel on
0 Replies
True of false if any column is non-blank
Ocasio27 in Excel on
1 Replies