Author: Mike Byrne
Date: 15:23:08 08/07/04
Go up one level in this thread
On August 07, 2004 at 18:15:37, Mike Byrne wrote: >On August 07, 2004 at 18:04:10, Duncan Roberts wrote: > >>excel only allows you 65,000 or so rows. If you want to change this so that many >>more are allowed. Is it just a question of changing an int to a long somewhere >>and how would you do it.? Or is it more complicated than that.? >> >> >>duncan > >You can't change Excel, use Access when have you more than 65,000 rows. ( it is actually 2^16 or 65,536 rows , for databases larger than 65,536 use Access for your data and then you can pull in summary data by selecting external data source when creating your pivot tables - assuming that is what you want to do)
This page took 0 seconds to execute
Last modified: Thu, 15 Apr 21 08:11:13 -0700
Current Computer Chess Club Forums at Talkchess. This site by Sean Mintz.