My query is this:
I have created a questionnaire answer template comprising of two worksheets.
One contains the answers and the second is a score sheet that links to the
cells in the answer sheet.
When linking cells between the workbooks, the numerical ones are fine.
However, a lot of the answers are in text form so to get round that, I set up
text boxes in the score sheet to link to the cells in the answer sheet. That
almost works apart from one thing:
As I type the text in the cell in the answer sheet, the text box in the
score sheet does not carry all of the text. Some stop in mid-word and I have
tried making the text box bigger, wrapping the text, but to no avail. I
wonder if anyone had any ideas? I'd be really grateful!

When using the link feature the same rules apply that are in effect when you
copy and paste; only the first 255 bytes are copied. To get around your
situation try to keep the answers to less than 255 characters.

"Alexlondon11" wrote:

My query is this:
I have created a questionnaire answer template comprising of two worksheets.
One contains the answers and the second is a score sheet that links to the
cells in the answer sheet.
When linking cells between the workbooks, the numerical ones are fine.
However, a lot of the answers are in text form so to get round that, I set up
text boxes in the score sheet to link to the cells in the answer sheet. That
almost works apart from one thing:
As I type the text in the cell in the answer sheet, the text box in the
score sheet does not carry all of the text. Some stop in mid-word and I have
tried making the text box bigger, wrapping the text, but to no avail. I
wonder if anyone had any ideas? I'd be really grateful!

Many thanks Stebro for getting back so quickly. I worked it out in the end.
It appears that the linked text box had a bit a trouble reading all the data
because the cell it was linking to was actually a group of merged ones.
Almost by accident, I found what I had to do was (and I don't even need text
boxes) to link the cell from the score sheet to a single cell in the answer
sheet. Bingo - I can write a short story and still get all the data in.
Many thanks for your suggestion though - much appreciated - I was starting to
despair!

Alex

"stebro" wrote:

When using the link feature the same rules apply that are in effect when you
copy and paste; only the first 255 bytes are copied. To get around your
situation try to keep the answers to less than 255 characters.

"Alexlondon11" wrote:

My query is this:
I have created a questionnaire answer template comprising of two worksheets.
One contains the answers and the second is a score sheet that links to the
cells in the answer sheet.
When linking cells between the workbooks, the numerical ones are fine.
However, a lot of the answers are in text form so to get round that, I set up
text boxes in the score sheet to link to the cells in the answer sheet. That
almost works apart from one thing:
As I type the text in the cell in the answer sheet, the text box in the
score sheet does not carry all of the text. Some stop in mid-word and I have
tried making the text box bigger, wrapping the text, but to no avail. I
wonder if anyone had any ideas? I'd be really grateful!