2006-12-05 03:56:03 · 5 answers · asked by lykyl 1 in Computers & Internet ➔ Programming & Design
It will export data until the 65536th row and then cut off.
2006-12-05 04:00:52 · answer #1 · answered by beanie 5 · 0⤊ 0⤋
Used to have this problem doing data analysis at BT - never tried to exceed the limit, though, as we knew it was there. We imported the raw data (regularly over a million items) into Access, filtered out the 5% (if that!) we were interested in and then transferred it to Excel for detailled analysis (ie. drawing pretty but meaningless 3D graphs), which a manager could pretend to understand and then do nothing with.
Evidently, the new 2007 version of Excel is able to cope with a million rows!
2006-12-05 05:53:20 · answer #2 · answered by Stephen L 7 · 0⤊ 0⤋
yet differently to confirm that further rows are regarded is to have the totals on the ideal of the column fairly than the backside. There are 2 tactics of accomplishing this a million. In row 2 cellular =SUM($A$3:oblique("A"& COUNTBLANK(IV;IV))) 2. in an no longer important section enter =SUM(A:A) strengthen row a million and insert a text cloth field above the header in A1. decide on the text cloth field, then in the formula field enter =(cellular ref of SUM formula) alter text cloth field length to adventure your standards. there's no would desire to function extra rows, only insert archives in next clean cellular.
2016-10-14 01:42:51 · answer #3 · answered by Anonymous · 0⤊ 0⤋
You get an error message telling you that the file is only partially loaded.
You may need to use Access instead.
2006-12-05 04:00:43 · answer #4 · answered by Well, said Alberto 6 · 1⤊ 0⤋
Try and find out !!!!!
2006-12-05 04:08:33 · answer #5 · answered by Blind Wing 3 · 0⤊ 1⤋