LinkBack URL
About LinkBacks
Hi Experts,
I had a file with formulas which is linked with another file (share drive different location). when i opened source file formulas become #REF error.
Please help.
regard,
suresh
Hi Experts,
I had a file with formulas which is linked with another file (share drive different location). when i opened source file formulas become #REF error.
Please help.
regard,
suresh
We already discussed this issue in another thread but unable to fix it since everything is working fine at our end.
Here is the link of that thread
http://www.excelforum.com/excel-form...k-is-open.html
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Almost impossible to say without more info. What are the formulas etc?
can you upload a sample of the workbooks?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I have the below formula which is linked with another file
=VLOOKUP(F3,'S:\MRP\2014\3-Mar\[MRP(Mar14-Dec14)_(28-2-14).xlsx]Summary'!A:E,5,0)
and when i open source file the formula becomes as #REF
=VLOOKUP(F3,'S:\MRP\2014\3-Mar\[MRP(Mar14-Dec14)_(28-2-14).xlsx]#REF'!A:E,5,0)
Thanks & Regards,
Suresh
Hi,
What's the result of the formula if the source workbook is closed?
Regards
Check whether you are opening the exact source workbook?
Or
The workbook which contains the same name and extension (Duplicate Copy) which stays in some other location?
Because after some testing found below possibility for this issue
We need 3 workbooks for this exercise:-
[1] For source workbook
[2] The workbook which needed for building the link to source workbook [1].
Build the links (In [2] workbook) and save both and close both of the files.
[3] Now create a new workbook and save it in some other location with [1] source workbook name and extension.
Now open the [3] workbook and keep it open and open the [2] workbook (formula workbook).
Now it will show #Ref error because the workbook is actually linked is another location file, but the current file which (is in open currently) posses the same file name of the source workbook but the source is different.
Close both [2] and [3] workbook. Now open only the [2] (formula workbook) now it will show the right result.
Hello everybody,
I struggled with this error for sometime before I found the solution mentioned elsewhere in this forum. To explain a bit - I save my referenced file in shared drive. The file is sent to me over email. I do a 'save' and browse to the shared drive folder.
The problem I face is that when I link it and keep both the files open, it works fine. If I close the file being referenced and re-open it, the worksheet name gets replaced by #ref. Like this - Q:\CONSO\2014ol\1409\abc\abc_22 Sep\Submission\[Sept14 v2.xlsx]#ref'!$E$107
The solution provided by Michael in this link here towards the end of the thread worked for me. Since I was saving it over the internet, the file was getting saved in the protected mode. And when I open the reference file the second time, the original file cannot reference the file in protected mode.
I switched off the protected mode from the trust center, and it works fine now.
Hi shiladazz,
Thanks for sharing the Enable Content info
I found this error was associated with a space in the source sheet name. Remove the space(s) in your sheet names, and see if the error still occurs.
Also, please post if this worked for you.
Hi Shiladazz,
I know this is an older post, but I'm having a very similar issue. In your post above, I don't see a link as mentioned. Any way you still have info on how to resolve? Thanks!
Hi smk81,
I stumbled across this thread while dealing with a similar issue myself. I discovered that someone had saved the file I'm referencing in my formulas in compatibility mode for Excel 97-2003. This was causing my links to show #REF whenever I opened the source file while I had the linked file open. To solve the issue I saved the linked file in compatibility mode as well and that resolved the issue. I haven't tested it the other way, but I assume changing the file type of the source file would correct the issue as well.
Solution: Go to File > Option > Trust Center. On right side, Click Trust Center Settings. In Trust Center window, on left side, click Protected View then on right side untick “Enable Protected View for files originating from the Internet”.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks