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

Links to the file were not updated because it was not recalculated

A

abhi2611

Member
Hi,

I have an excel workbook that has almost 200 links from other excel workbooks. Every time I try to update all the links, a message box pops up saying "Links to the file XXXX was not updated because XXXX it was not recalculated" when I know the file XXXX was updated. Is there a way to avoid these message boxes. I just don't want to sit and keep clicking OK on every message box that pops up while I could work on something else when this file is being updated.

Any help is appreciated.

Thank you,
A.G.
 
From some digging, I found this
*Actual links* will work on open and/or closed WBs, so I'm assuming that you're talking about formulas that reference other WBs.

Certain functions *do not* work on closed files, such as Sumif(), Countif(),
and Indirect(), among others.
Click to expand...
That would be my guess as to what is going wrong. That would also indicate that your workbook is not displaying good information. Best solution would be to redesign the links to pull in info correctly, and then perform calculations. Or, have formulas in source file, and link to the formulas there.
 
Luke,

Thanks for looking into this. The thing is all the calculations are done in the source file itself. My workbook is more like a summary that just links into the source file to bring the information. I did not have this problem when I used Excel 2007. This started after we switched to Excel 2010 and change the files to .xlsb
 
Hmm. And all the links you have are direct links e.g.
='[Other book.xlsb]Sheet1'!A1
and not buried within a formula or Named Range formula?

To clarify, the source file changed to xlsb, current file changed to xlsb, or both?
 
You must log in or register to reply here.
Back
Top