Quote Originally Posted by Admin View Post
Hi

I have just moved your post in the right forum.

As far as VALUE error, I think the SUMIF won't work if the source workbook is not opened. So you can do one thing to overcome this, not to update the links while opening the workbook. That way you can preserve the formula values.
Thanks for moving my post in the right forum.

Actually Excel doesnt show any dialogue box for update the link. It just shows VALUE ERROR even when I close source file. This is only happen in the files which I export from accounting software. Otherwise both SUMIF and VLOOKUP work fine and I dont have to open the source file.

Let me tell you more clear about the file. When I export Excel File from software its extension is XLS (All Capital) format. I dont know whether capital letters effter file format or not. If I add any worksheet in the workbook and then close it, it shows a dialogue box that I will not save my more than one sheet and ask me to SAVE AS file in other format. Then I have to choose the other format. In order to view the results of any formula which is linked with other files, I have to open the source file too.

If there is any solution please let me know.


Thanks

Regards

Suhail