G
Guest
Does anyone know of a way to increase the maximum number of rows (65,536) on
a worksheet ? I maintain an application which queries a shipments database
which grows beyond this limit late in the year. Splitting the data between
two worksheets is an obvious option, but complicates the production of
numerous reports and pivot tables. Or I can redo the entire application in
Access, but that would involve considerable effort and retraining of users.
Is there a third-party add-in which can be purchased ? Any suggestions would
be greatly appreciated.
Thanks,
Chris Curry
a worksheet ? I maintain an application which queries a shipments database
which grows beyond this limit late in the year. Splitting the data between
two worksheets is an obvious option, but complicates the production of
numerous reports and pivot tables. Or I can redo the entire application in
Access, but that would involve considerable effort and retraining of users.
Is there a third-party add-in which can be purchased ? Any suggestions would
be greatly appreciated.
Thanks,
Chris Curry