• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

link breaks between two files saved on the server everytime I open it

R

RSidhu

Member
I have used simple = from one file to the other and I have also used array formulas. but the file always ref#s out or N/As out. it is very frustrating as I have to fix it everytime.

Can someone please help with a solution?

Thanks
 
Do you happen to use external reference with file name only?
Something like...
='[example.xlsx]Sheet1'!$A$1

This only reference open workbook. To reference closed workbook, you need full file path.
Something like...
='C:\Reports\[example.xslx]Sheet1'!$A$1

Note that many functions like SUMIF / COUNTIF etc only work if the referenced file is open. If this is the case, make sure you open the referenced file before the workbook with the formula.

Other common causes:
1. Network drive letter changed
2. Temporary connectivity issue with network drive
3. There is security setting enforced by GPO or some other method that is preventing Excel from using data link without permissions
 
Thank you. I simply link the files and the path gets automatically made. What is the solution to fix this?
 
Without knowing your set up, it's hard to say.

Few things I can think of...

1. Check if network drive is added as trusted location.
2. Make sure network drive is set to reconnect upon login
3. If network drive is mapped through GPO and/or logon script, check with your IT
 
You must log in or register to reply here.
Back
Top