Hi

I have a few workbooks that are linked to a workbook that I recieve from an external source. I save the external workbook daily as the same file, in effect saving over it. The workbook I recieve apparently has some sort of macros because it asks whether to allow them, but I can see nothing in the vbe.
Whenever I open one of the workbooks that are linked to this external workbook, I choose to update links. However, a dialog pops up saying links could not be updated, Continue or Edit Links. When I choose Edit Links, the external book is listed but under Status it says Warning: Source not recalculated. If I hit Update Values, another pop up comes up saying: Links to ...xls were not updated because ...xls was not recalculated before it was last saved.

The only way to update my links is to open the external workbook.
What is causing this problem, and how do I get around it?

Thanks!