Excel array truncates data

[Neil]

Can someone more intelligent than me help with this? I'm using the
following array to match firstname, surname and set and retrieve some
data as a result:

=INDEX('[ICT GCSE.xls]2011'!BR$4:BR$92,MATCH(1,('[ICT GCSE.xls]2011'!$C
$4:$C$92=Progress!$D$3)*('[ICT GCSE.xls]2011'!$B$4:$B$92=Progress!$D
$5)*('[ICT GCSE.xls]2011'!$F$4:$F$92=Progress!$D$7),0))

The problem is the data return is truncated to 255 characters but I
need to return up to 1000 characters or possibly higher. Can this be
done?

 

[Dave Peterson]

I bet it's returning 255 characters when the sending workbook is closed.

If you open it (and recalc), you should see everything.

The 255 character limit when the sending workbook is the way excel/windows work.
I've never seen any work-around for this. (Except for opening the workbook.)

Can someone more intelligent than me help with this? I'm using the
following array to match firstname, surname and set and retrieve some
data as a result:

=INDEX('[ICT GCSE.xls]2011'!BR$4:BR$92,MATCH(1,('[ICT GCSE.xls]2011'!$C
$4:$C$92=Progress!$D$3)*('[ICT GCSE.xls]2011'!$B$4:$B$92=Progress!$D
$5)*('[ICT GCSE.xls]2011'!$F$4:$F$92=Progress!$D$7),0))

The problem is the data return is truncated to 255 characters but I
need to return up to 1000 characters or possibly higher. Can this be
done?

 

[Bear]

I bet it's returning 255 characters when the sending workbook is closed.

If you open it (and recalc), you should see everything.

The 255 character limit when the sending workbook is the way excel/windows work.
  I've never seen any work-around for this.  (Except for opening the workbook.)

Can someone more intelligent than me help with this? I'm using the
following array to match firstname, surname and set and retrieve some
data as a result:

=INDEX('[ICT GCSE.xls]2011'!BR$4:BR$92,MATCH(1,('[ICT GCSE.xls]2011'!$C
$4:$C$92=Progress!$D$3)*('[ICT GCSE.xls]2011'!$B$4:$B$92=Progress!$D
$5)*('[ICT GCSE.xls]2011'!$F$4:$F$92=Progress!$D$7),0))

The problem is the data return is truncated to 255 characters but I
need to return up to 1000 characters or possibly higher. Can this be
done?

Cheers. Was hoping not to have to open the workbook. But even once
open the data is still truncated although I haven't counted by how
many characters. Does this also affect the 2010 version?

 

[Dave Peterson]

I don't know. I haven't installed xl2010 (yet).

I bet it's returning 255 characters when the sending workbook is closed.

If you open it (and recalc), you should see everything.

The 255 character limit when the sending workbook is the way excel/windows work.
I've never seen any work-around for this. (Except for opening the workbook.)

Can someone more intelligent than me help with this? I'm using the
following array to match firstname, surname and set and retrieve some
data as a result:

=INDEX('[ICT GCSE.xls]2011'!BR$4:BR$92,MATCH(1,('[ICT GCSE.xls]2011'!$C
$4:$C$92=Progress!$D$3)*('[ICT GCSE.xls]2011'!$B$4:$B$92=Progress!$D
$5)*('[ICT GCSE.xls]2011'!$F$4:$F$92=Progress!$D$7),0))

The problem is the data return is truncated to 255 characters but I
need to return up to 1000 characters or possibly higher. Can this be
done?

Cheers. Was hoping not to have to open the workbook. But even once
open the data is still truncated although I haven't counted by how
many characters. Does this also affect the 2010 version?