Other people get #REF! error when I send them files with links - is there a way to prevent this without breaking links each time?

[Paul10019]

Hi,

This problem just started when I joined a new company so I am guessing there must be a setting that I can adjust.

Other people get #REF ! errors when they open files that have links when I send them via email.

Is there a way to fix this without breaking all the links each time I send files?

I have searched these forums and the web but haven't found something that addresses this probably exactly...

Thank you!

 

[Scott T]

What formula are you using? Some functions only work on open workbooks like SUMIF, COUNTIF, INDIRECT...

 

[Paul10019]

Just a straight link... i.e. ='[TAB NAME]WORKBOOK NAME'!$D$9

I generally use sumproduct but these links don't warrant sumproduct...

 

[Scott T]

Where are the files located and do the other users have access to the location with the same path?

I do not have a drive Z mapped and this will give me a REF error.

='z:\Users\username\Desktop\[book1.xlsx]Page1_1'!$G$5

 

[Paul10019]

Files stored on a shared drive. Many of the file recipients do not have access to the drive, though some do.

 

[Scott T]

When they open the file do the get the protected view bar? If they are do they click enable editing?

 

[bhandari]

i think they are missing few files

check the missed files from Ribbon bar
Go to Data then Edit Links
to figure out Missing file