| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007 can not filter / sort in sheet with 657,000 rows
I upgraded to Office 2007 when I heard that the new upper lmit in Excel was
1MM rows. I am running Offide 2007 Enterprise on XP Pro SP2 on a machine with 4GB Ram and dual Intel zeon 3.06Ghz processors. I generated the workbook from Crystal Reports XI. I converted it to the ..xlsx format. There are no protection or incompatability issues that Excel can find. When I choose the DATA menu, all options are grayed out. Any clues? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel 2007 can not filter / sort in sheet with 657,000 rows
Make sure the sheet is not protected (Review tab). And that it is not
"shared" (also Review tab). -- Jim "Charlie Ruddy" <Charlie wrote in message ... I upgraded to Office 2007 when I heard that the new upper lmit in Excel was 1MM rows. I am running Offide 2007 Enterprise on XP Pro SP2 on a machine with 4GB Ram and dual Intel zeon 3.06Ghz processors. I generated the workbook from Crystal Reports XI. I converted it to the .xlsx format. There are no protection or incompatability issues that Excel can find. When I choose the DATA menu, all options are grayed out. Any clues? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 data corruption using sort within a filter. | Excel Discussion (Misc queries) | |||
| How do I sort or filter rows without column A data changing? | Excel Discussion (Misc queries) | |||
| Columns A - BY and 336 rows.Too much to filter&sort?Lose info. | Excel Worksheet Functions | |||
| Columns A - BY and 336 rows.Too much to filter&sort?Lose info. | Excel Worksheet Functions | |||
| Filter, sort, lookup from other sheet | Excel Discussion (Misc queries) | |||
Linear Mode
