Link references work within my document, however they show up #value on my boss's

Hello! I am new to this community, hopefully you guys may be able to help me figure this out.

I created an excel sheet with many "sheets". All of the sheet's values are referenced from one master source sheet.

I used ='SOURCE'!J5 (just an example), to link. This works fine and updates automatically in my document.

I save my Excel workbook in "Drop Box". My boss and co-workers cannot see the referenced cells. They show up at #value!! (or something similar).


*I have also tried emailing the document, and that does not work either. USING EXCEL 2011 FOR MAC