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

fnarf at comcast.net fnarf at comcast.net
Fri Mar 19 13:51:58 PDT 2010


65,536 in Excel 2003 and I think all others.

Excel's not a good tool for this; do you feel like learning Access?



----- Original Message -----
From: victrola78s at aol.com
To: 78-L at 78online.com, 78-l at klickitat.78online.com
Sent: Friday, March 19, 2010 1:46:57 PM GMT -08:00 US/Canada Pacific
Subject: Re: [78-L] 78s Excel spreadsheet-how many entries is the max?

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



More information about the 78-L mailing list