Smurf wrestles with Excel 2007 external link error
Posted by AccountingWEB PM | on Thu, 12/03/2009 - 12:59 2270
In his Smurf on spreadsheets blog, Simon Murphy highlighted a data linking anomaly that causes reference errors when you open a worksheet that contains the source cell for an external link
As described by Smurf, the problem can be replicated by opening two workbooks and saving them as .xlsm files.
If you put text in a cell on one workbook and link to it from the other and then save and close both workbooks, when you reopen them (source file first), Exc
Continued...
The full article is available to registered AccountingWEB members only. To read the rest of this article you’ll need to login or register.
Registration is FREE and allows you to view all content, ask questions, comment and much more.
Or if you are already registered, login here
