E
Erwin Broekhuis
Hi,
I'm having a problem with linking an Excel spreadsheet in a report using the
Unbound Object Frame.
The spreadsheet is displaying just fine, except for one thing: It only shows
20 columns! It cuts off after column "T", while the real document ends at
"AF".
At first I thought it was because the "size mode" property of the frame was
set to "cut off", but after changing that to "zoom" and also "stretch", I
found out that's not it.
I tried forcing the frame to pick up the lost rows by setting the "Source
Item" property to "A1:AF54", to no avail.
I tried to embed the spreadsheet as well (instead of linking it), but that
doesn't change anything either...
I created several test spreadsheets and found out they all stop after column
20.
-- Am I missing something here, or is there a hard limit of 20 columns? I
sure hope that's not the case.
Help would be much appreciated!
(I'm using Access 2003, SP2)
Thanks!
--Erwin
I'm having a problem with linking an Excel spreadsheet in a report using the
Unbound Object Frame.
The spreadsheet is displaying just fine, except for one thing: It only shows
20 columns! It cuts off after column "T", while the real document ends at
"AF".
At first I thought it was because the "size mode" property of the frame was
set to "cut off", but after changing that to "zoom" and also "stretch", I
found out that's not it.
I tried forcing the frame to pick up the lost rows by setting the "Source
Item" property to "A1:AF54", to no avail.
I tried to embed the spreadsheet as well (instead of linking it), but that
doesn't change anything either...
I created several test spreadsheets and found out they all stop after column
20.
-- Am I missing something here, or is there a hard limit of 20 columns? I
sure hope that's not the case.
Help would be much appreciated!
(I'm using Access 2003, SP2)
Thanks!
--Erwin