I am trying to paste 40 cells from an Excel worksheet (which I used in order
to format the cells with rotated text) into the page header of my report and
two things happen - when I copy the Excel cells and paste them into the
report, only half of the cells actually paste so I have to break into 2 sets
of cells. Then when the report spans 2 pages due to width being greater than
page width, the OLE drops the contents of those cells which fall to the right
of the first page. The cell lines still print but the text disappears. Does
anyone have an idea of what's going on here? Or are you able to suggest
another way to get rotated text as the report column titles?
Thanks!
|
|