Linking cells - text cut off if too lengthy

[firelinecr]

I am working on some budgets for my employer, I have about 15 differen
spreadsheets that info is pulled from to compile in to 1 spreadsheet.
There are many links, as you can imagine, to pull this info in and the
all work pretty well with one exception. If there is too much text i
one cell that I am trying to link to my main spreadsheet, it cuts of
(most the time mid-sentence) and does not pull all of the informatio
from the original sheet. The only way it will pull the info in it
entirety is if I have both/all spreadsheet(s) I am pulling from open a
the same time, which defeats my purpose of compiling it in to on
sheet. Any ideas??!

 

[Dave Peterson]

This is the way excel works.

You may want to go to the original cell and break it up into pieces. Then
retrieve each piece into different cells.

You could build a formula that retrieves it in a piecewise manner, but remember
that excel's formulas are limited to 1004 characters (when in R1C1 mode).

And with closed workbooks, this can limit your formula a whole heckava lot.