Excel 2007 can not filter / sort in sheet with 657,000 rows

  • Thread starter Thread starter Charlie Ruddy
  • Start date Start date
C

Charlie Ruddy

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?
 
Make sure the sheet is not protected (Review tab). And that it is not
"shared" (also Review tab).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing CSV file with more than 65535 rows to Excel 2007 9
How to have more than 65,000 rows in excel 2007 3
Delete Filtered Rows in Excel 2007 7
Deleting rows in Excel 2007 using filters 1
Problems copying Large Amounts of Data in Excel 2007 1
Resources required for excel 2007 4
copying filtered data in Excel 2007 2
cannot delete filtered rows in excel 2007 3

Back
Top