Every time I open a workbook (2007 xlsx) I get a message saying one or more links cannot be updated.
I deleted all links and got no error on open as expected. Then I put back just one link from another book and got the error again, even though changing the value shows that the link is working perfectly. I get the error no matter which other book I link to.
Seem to get this problem in at least one of my accounts workbooks every year, only solution I've found is to create a new book and paste everything into it, a right hastle.
Any better ideas? Ta.
I deleted all links and got no error on open as expected. Then I put back just one link from another book and got the error again, even though changing the value shows that the link is working perfectly. I get the error no matter which other book I link to.
Seem to get this problem in at least one of my accounts workbooks every year, only solution I've found is to create a new book and paste everything into it, a right hastle.
Any better ideas? Ta.
Comment