Excel array truncates data

  • Thread starter Thread starter Neil
  • Start date Start date
N

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?
 
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?
Click to expand...
 
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:
Click to expand...
=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))
Click to expand...
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?
Click to expand...
Click to expand...

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?
 
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:
Click to expand...
=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))
Click to expand...
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?
Click to expand...
Click to expand...

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?
Click to expand...
 
Back
Top