Hello,
I am referencing cells of a workbook (cells contain sentences/paragraphs)
from another workbook. When the workbook (doing the referencing) opens and
the user chooses "Update" several of the sentences are cut off in a fraction
of the cells. Is there a limit to the number of characters each cell
reference can transpose (for lack of a better word) from the second document?
If there is a limit, does the length of the file path to the referenced
document count toward the number of characters? Lastly, is there a way to
capture and display all of the information in each of the referenced cells
without truncating the information (maybe some sort of copy rather than
referencing?).
Please Reply,
--
Mike Nowak