[78-L] 78s Excel spreadsheet-how many entries is the max?

[Gene Baron]

Excel 2003 and earlier versions do have this limit per tab or worksheet.
You can have more than one tab but you'd get a large and fragmented set of
data.  I have not worked with it but Excel 2007 is supposed to have finally
done away with this and will allow up to 1,000,000 rows.  I agree though
that Access or a program such as Catraxx (which is built on Access
databases) would be better.

Gene
gene.baron at gmail.com

On Fri, Mar 19, 2010 at 4:46 PM, <victrola78s at aol.com> wrote:

> Quick question here-how many individual entries(lines?) is the max you
> can put into an Excel file? I've just started one of these with enough
> categories(cells?) to satisfy me, & for an album with more than one
> piece or song I am making separate entries for each. Now, hold down the
> snickering, I'm a novice at "office work" so I'm fumbling me way
> through. For example, if one had an Lp containing 6 songs per side,
> that's 12 separate entries per album title entered. Same with 78 rpm
> album sets of classical, I am putting each side number-possibilty of
> 10-12 entries per album title there too. If one had 5,000 Lps, or an
> equal number of 78 album sets, the total number of "lines" entered
> would be in the many thousands. So then, how many entries can the Excel
> spreadheet hold?
>
> Dennis "burned-out" Forkel
> _______________________________________________
> 78-L mailing list
> 78-L at klickitat.78online.com
> http://klickitat.78online.com/mailman/listinfo/78-l
>