The values will also update when I shut down a workbook and re-open, or if I press Shift Ctrl Alt F9, it will do it, but not during a normal F9. I think it is highly likely that it is due to the file size.
The files are very big, one is 70 meg, the other two are around 30meg each.
The external workbook links are a tiny fraction of the total number of calculations in the model. But I think it is the sheer number of calculations in the whole model that the computer can't keep up with.But if this is the case, why will the internal worksheet calculations be calculated, but the external workbook links not?The workbook that contains the links is called the destination workbook, and the workbook that is linked to it is called the source workbook.If the workbook that you have opened (called a destination file) contains links to other workbooks or files (called source files), and the source files have changed, the links in the workbook that you are opening may display information that is out of date. The destination workbook contains the external reference. The external reference (or link) is a reference to a cell range in the source workbook. The source workbook contains the cell and the actual value that is retrieved and placed in the destination workbook.You can control whether the Trust Bar alerts you, and whether to update all links when the alert does not appear.
You can also update only some of the links, if the workbook contains more than one link.Hi I am working with three excel workbooks where data flows between them.For some reason, the workbook links aren't updating, when they should.I want to give the link between excel file to Bom in solidworks...I used excel based Bom but if i want to change the data in excel file then that data should be updated in solidworks BOM .. Even though intuitively one would think this has to be checked. Startup prompt = Don't display the alert and update links. after you confirm this will think some other point. Regards, DILIPandey Yes, when clicking Change Source he is updating. And now he seems to update dynamically all of a sudden.