• 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.

#VALUE! error in excel link

J

Jignesh Joshi

New Member
Hi

One of my excel file is linked to another excel file through SUMIF function.
When i open the file it shows me #VALUE! error.
To fix this problem if I open 2nd file (with which it is linked) then link works OK
So I have to keep both file open to make link working.

Can some one help to fix this.

regards
jignesh
 
Hi Jignesh ,

I tried out the SUMIFS function , and it did not give any error ; I assume SUMIF will also not give an error.

Can you post your formula which is giving an error ?

Narayan
 
Hi, Jignesh Joshi!
Does the linked workbook has any calculations made at open time (macro run when opening), connections to other data sources (data retrieval), or volatile formulas like NOW() or TODAY() that can change the linked cell and it dependent ones content?
Post the linked cell formulas too. Thank you.
Regards!
 
Hi Narayan

I am not sure whether it is because of sumif or something else?
=ROUND(SUMIF('W:\[Labour Costs Sep 13.xlsx]Wk01'!$B:$B,C117,'W:\[Labour Costs Sep 13.xlsx]Wk01'!$C:$C),2)
jignesh
 
Hi SriJB7

both are simple excel files (without Macro). I have to Paste data in one file from where it comes in 2nd file. Both have file extension .xlsx
If I keep both open, then it shows numbers correcty (link works) but if another is not opened then I get this error.
 
Hi Jignesh ,

Sorry , my mistake ; SUMIF does give an error.

It did not give an error when I opened the file , but when I forced a Recalculate , it gave an error.

Narayan
 
You must log in or register to reply here.
Back
Top