Reference to another document

[Pasty]

Hi there,

I have a register which has cells linked up to another document like this

='http://knet/sites/fapas/risk/InformationSecurity/IS
Documents/Plan/[Statement of Applicability.xls]Annex A and New SOA'!I93

In some of the cells it is cutting out some of the information at the end of
the sentence.

Is there a reason for this?

 

[Dave Peterson]

If you open that "sending" workbook and reevaluate your formula, do you see all
the text?

If yes, then I bet the string you're retrieving is greater than 255 characters.

Excel will only retrieve the first 255 characters from a closed workbook. It's
a limitation of excel. I've never seen a work-around that's pretty (put your
data in multiple cells and retrieve it multiple times?).

Hi there,

I have a register which has cells linked up to another document like this

='http://knet/sites/fapas/risk/InformationSecurity/IS
Documents/Plan/[Statement of Applicability.xls]Annex A and New SOA'!I93

In some of the cells it is cutting out some of the information at the end of
the sentence.

Is there a reason for this?