geraldartman
New Member
- Joined
- May 30, 2009
- Messages
- 4
I am trying to work with a 500,000 to 700,000 row table in XL07. It imports the CSV file ok. I can copy 10,000 lines from another workbook into the table ok. But it chokes on other simple things.
I added five columns to compute some result keys for building a pivot table. Then I was making a 6th column to add two of those together, it dies. I mean it runs calculation and does the blank screen likes it's going to redraw and I get the send error dialog. The equation is simple math Col X + Col Y.
I have a 8 month old Lenovo laptop. I was wondering if this is a memory issue or some other settings? I turned off auto backups and most all error checking. I am using manual calc. No lookup tables or external references.
Perhaps its hype about being able to handle million row tables
Any ideas would be appreciated. Otherwise I'll search for other analysis tools. Bummer, I have many other worksheets with tens of thousands of rows without problems.
I added five columns to compute some result keys for building a pivot table. Then I was making a 6th column to add two of those together, it dies. I mean it runs calculation and does the blank screen likes it's going to redraw and I get the send error dialog. The equation is simple math Col X + Col Y.
I have a 8 month old Lenovo laptop. I was wondering if this is a memory issue or some other settings? I turned off auto backups and most all error checking. I am using manual calc. No lookup tables or external references.
Perhaps its hype about being able to handle million row tables
Any ideas would be appreciated. Otherwise I'll search for other analysis tools. Bummer, I have many other worksheets with tens of thousands of rows without problems.