K
k.alan
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have established links between Workbook "A" and each of 13 other workbooks.
1. When I change a linking formula in "A", the "Link" dialogue box opens and asks me to re-define the link (i.e. to the appropriate workbook the new formula references).
2. When I open "A", the "Link" dialogue tells me it cannot find any of the 13 source files, asking me to re-define all the links, even though the links have already been defined and the file locations have not been changed. This happens even if the 13 workbooks are open.
This shouldn't be necessary. What am I missing?
Thanks.
(As usual the Excel help is of no help; all the suggested topics have nothing to do with the problem.
1. When I change a linking formula in "A", the "Link" dialogue box opens and asks me to re-define the link (i.e. to the appropriate workbook the new formula references).
2. When I open "A", the "Link" dialogue tells me it cannot find any of the 13 source files, asking me to re-define all the links, even though the links have already been defined and the file locations have not been changed. This happens even if the 13 workbooks are open.
This shouldn't be necessary. What am I missing?
Thanks.
(As usual the Excel help is of no help; all the suggested topics have nothing to do with the problem.