| View previous topic :: View next topic |
| Author |
Message |
vijaykhurana
Newbie
Joined: 21 Aug 2009
Posts: 3
|
 Posted: Thu Sep 17, 2009 10:33 pm Post subject: pivot table on more than 5000 rows |
 |
|
| data pilot when applied on a calc sheet with more than 5000 rows and 6-7 cols either takes too long to complete or simply hangs |
|
| Back to top |
|
 |
Karun
General User
Joined: 16 Jul 2008
Posts: 28
Location: DELHI
|
| Posted: Thu Sep 17, 2009 11:10 pm Post subject: DATA PIVOT |
|
|
here i hav same prob., i had upload the file.
plz find the solution.....
------------------------------------------------------
http://www.mediafire.com/?uz71wxdazu4
-------------------------------------------------------
THK |
|
| Back to top |
|
|
ftack
Moderator
Joined: 27 Jan 2003
Posts: 3102
Location: Belgium
|
| Posted: Fri Sep 18, 2009 12:15 am Post subject: |
|
|
There are limitations in what pivot tables in Calc can handle. For heavy data processing, you need to resort to a database program at some point.
_________________
--
GNU/Linux (Ubuntu) |
|
| Back to top |
|
|
jrkrideau
Super User
Joined: 08 Aug 2005
Posts: 6733
Location: Kingston ON Canada
|
| Posted: Fri Sep 18, 2009 2:04 pm Post subject: Re: DATA PIVOT |
|
|
| Karun wrote: | here i hav same prob., i had upload the file.
plz find the solution.....
------------------------------------------------------
http://www.mediafire.com/?uz71wxdazu4
-------------------------------------------------------
THK |
Use a data base. You have over 600,000 entries in that one sheet.
As ftack says some things are too much for Calc.
_________________
jrkrideau
Kingston ON Canada
Currently using Windows 7 & OOo 3.4.0 and Ubuntu 12.04 & LibreOffice 3.5.2.2 |
|
| Back to top |
|
|
|
