How many entries can Excel handle!?
in [General]
|
Prev: Function to determine if a cell contains a formula
Next: How can I test for nulls within a range without specifying eac
From: Rebecca Sage on 25 Mar 2010 13:29 I have close to 1000 entries in my Excel spreadsheet, and am trying to figure out why entries are coming up missing. I often do custom sorts. This may be when entries get tossed out?
From: Luke M on 25 Mar 2010 13:38 You are no where near the limit. Check out the help file article "Excel limits and specifications". There must be something else going on. -- Best Regards, Luke M "Rebecca Sage" <RebeccaSage(a)discussions.microsoft.com> wrote in message news:4241294E-484E-4A8A-9304-0E0C45E643A3(a)microsoft.com... >I have close to 1000 entries in my Excel spreadsheet, and am trying to >figure > out why entries are coming up missing. I often do custom sorts. This may > be > when entries get tossed out?
From: trip_to_tokyo on 25 Mar 2010 14:11 EXCEL 2007 can handle:- 1,048,576 rows by 16,384 columns Please hit Yes if my comments have helped. Thanks. "Rebecca Sage" wrote: > I have close to 1000 entries in my Excel spreadsheet, and am trying to figure > out why entries are coming up missing. I often do custom sorts. This may be > when entries get tossed out?
From: JLatham on 25 Mar 2010 14:18 And Excel 2003 has a limit of 65535 rows and 256 columns. Your 1000 entries really should not be a problem. Have you checked to see if perhaps your special sorting has placed some entries in places on the sheet where you may not be looking? A quick way to find out how far down and over on a sheet your data extends is to click in a cell on a sheet and then press [Ctrl]+[End]. This will take you to the lower right corner of the used range on a sheet. You can then start looking to the left and up the sheet for your data. "Rebecca Sage" wrote: > I have close to 1000 entries in my Excel spreadsheet, and am trying to figure > out why entries are coming up missing. I often do custom sorts. This may be > when entries get tossed out?
From: Bob I on 25 Mar 2010 17:47
1000? that is a filter limit for unique items. Rebecca Sage wrote: > I have close to 1000 entries in my Excel spreadsheet, and am trying to figure > out why entries are coming up missing. I often do custom sorts. This may be > when entries get tossed out? |