This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I MADE A DATABASE AS WELL AS SEPERATE SPREADSHEETS THAT FEED OFF THIS DATABASE. EVERYTHING WORKS PERFECTLY ON MY COMPUTER BUT WHEN I TRY TO SHOW ANOTHER COLEGUE FOR WHEN I AM NOT AT WORK THE FORMULAS CHANGE AND STOP WORKING.
MY FORMULA READS
DATABASE.xlsx!Table5[COMMENTS]
BUT WHEN WE OPEN IT ON HER COMPUTER IT READS THE ENTIRE PATHWAY IN THE FORMULA. AND ALL THE CELLS READ #REF
ANYONE ABLE TO HELP WITH THIS?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
PLUS I HAVE OTHER THINGS ATTACHED TO THE SOUCR FILE ON THE TARGET FILE AND THEY STILL WORK
SHE HAS TO FOR THE FORMULAS TO WORK. PLUS THE SOURCE FILE HAS A HYPERLINK TO THE TARGET FILE. MAKES IT EASIER TO NAVIGATE TO THE TARGET FILE.
Have you tried let users open both source file and target file?
SO ON MY SCREEN I SEE THIS AND IT WORKS
BUT WHEN SOMEONE ELSE LOOKS AT IT, IT LOOKS LIKE THIS. MY COWORKER DOES HAVE COMPLETE ACCESS TO THE SHARED DRIVE.
Could you share a screenshot of your formula which is not working? It seem that source file is accessible on her computer.
The #REF! error shows when a formula refers to a cell that’s not valid.