I
infinitedark
I have a summary file that has 15 links to 7 files in a single cell.
When all the files that are being linked to are open, there is no
problem. When just the summary file is open however, the formula box
displays the entire path and filename which gets quite lengthy. In
Excel 1997, the formula box cuts off after 1,054 characters I believe,
so some of the links get cut off in the formula box. However it does
appear Excel maintains the links as long as no changes are made.
(Changes can be made safely with all linked files open) The end
result is I'm not sure how much faith I can have that the links will
be okay.
Do future Excel versions have similar limitations on the formula box?
And, has anyone else encountered this problem and can reassure me that
the links indeed will be okay?
When all the files that are being linked to are open, there is no
problem. When just the summary file is open however, the formula box
displays the entire path and filename which gets quite lengthy. In
Excel 1997, the formula box cuts off after 1,054 characters I believe,
so some of the links get cut off in the formula box. However it does
appear Excel maintains the links as long as no changes are made.
(Changes can be made safely with all linked files open) The end
result is I'm not sure how much faith I can have that the links will
be okay.
Do future Excel versions have similar limitations on the formula box?
And, has anyone else encountered this problem and can reassure me that
the links indeed will be okay?