database report structure issues?

  • Thread starter Thread starter Anna Que
  • Start date Start date
A

Anna Que

Hi,
I have a exel table which calculates # codes that needs to b
associated to graphics and text for a 20 to 30 page formated report.
stored the graphics on a few sheets of a workbook and the text also o
several sheets. I use VLOOKUP to pull the assoc. #s to graphics an
text to the report templete pages

I tryed to paste the text to a cell and then a grouped cell and when
called this text to the report page most text was missing and som
clipped off. I tryed to call the text to the report sheet in a text bo
and a large group of cells with the same result.

Is there a character limit in the cells I am reaching? If so how to ge
around this.

Maybe exel is the wrong program for my need?

Anna

:confused
 
I don't recall any problem I've had with text being retrieved if the "sending"
workbook was open.

If the "sending" workbook is closed, 255 characters is the limit.

==
Any chance you just need to increase the rowheight/columnwidth for that cell?
 
Thanks, I am not saving from a worksheet, it is a folder of text file
which I have pasted into the worksheet then VLOOKUP to the repor
templete. I have half a grouped cell of space left in the templete. I
the source worksheet it shows in the formula bar window all of the tex
file within the cell. It is well over 255 characters.

Ann
 
Does Grouped cell mean merged cells.

If yes, then they don't respond to autofitting rows, but you can manually resize
them.

If you're losing characters at about the 1000 character mark, then you can
insert some alt-enters to force new lines in the cell. You can see lots more
characters that way.
 
Yes they are grouped, because the format of the additional graphics wont
allow me to set a cell that large. How do you set alt in a cell? Do this
from the source cell or the destination cell?

Thanks again Anna
 
If it's a formula, I would put it in the source cell.

(Remember to check: format|cells|alignment tab|wrap text)

You can actually hit alt-enter while typing the text into a cell. Or if the
source cell will be a formula that concatenates multiple cells, you can do this:

=a1&char(10)&b1&char(10)&c1
(wraptext on this one, too.)

And just try typing this in an unused cell:

This is a (hit and hold ALT, then hit enter) test of (alt-enter)newlines.

(If you see a little square, then you didn't toggle the wraptext checkbox.)
 
Back
Top