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
Bookmarks