Re: Pivot Table sort by count of crashes 2008 but not 2004
- From: Fergal Condron <fercon@xxxxxxxxxxxxx>
- Date: Thu, 07 Aug 2008 10:40:15 -0700
Hey there,
As you can see from my post below, this is something that we are aware of
and trying to find a solution. If you select the column you want to sort
and then use the Data\Sort menu item and select 'Descending' do you still
get the same results as expected?
Thanks,
Fergal.
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided “AS IS” with no warranties, and confers no rights.
On 8/6/08 6:48 PM, in article
88898AD1-2479-467A-AD9E-DCDF60533E64@xxxxxxxxxxxxx, "komisch"
<komisch@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Anyone know a workaround other than sorting in Excel 2004?
I have a table of 14 columns, 495 rows. I select the data in all the columns
and rows manually (not selecting the whole table as I have read that can
cause problems, and I have seen that it slows performance when calculating
the report by a significant amount)
I then perform a pivot table report and do a sort on one of the columns.
This works fine. However, once I try to specify the report should be
descending on the count of that column, Excel 08 always crashes.
I have tried selecting just the data in the column I want to sort on, e.g.,
I have a column called "products" and instead of selecting all 14 columns, I
simply select the Product column. When I do the pivot table, all works well.
When I try to descend on count of "Product," it crashes.
The only way I have found around this is to save the file in .xls format,
open it in Excel 2004, do the descend on count sort there, and then open it
in Excel 2008. That has no issues, but then what is the point of having the
latest Excel if I have to use the previous version?
"Fergal Condron" wrote:
Actually please disregard my last post, I just reproduced this on my Tiger
machine.
I'll escalate the issue.
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.
On 7/3/08 12:24 PM, in article C4927577.10D0D%fercon@xxxxxxxxxxxxx, "Fergal
Condron" <fercon@xxxxxxxxxxxxx> wrote:
Hi there,
Could you give me some more details about your issue?
What OS are you running? I tried to reproduce what you are seeing but have
no yet been successful. I created a pivot table and changed the Field
settings to automatically sort but this works as expected for me.
Is there any way that you can send me a sample file? My email is
fercon@xxxxxxxxxxxxx
Fergal Condron,
Macintosh Business Unit
Microsoft Corp.
This posting is provided ³AS IS² with no warranties, and confers no rights.
On 7/3/08 2:55 AM, in article 59b526b3.0@xxxxxxxxxxxxxxxxxxxxxxx, "Sergio"
<Sergio> wrote:
The same problem here. All the pivots with pre-sorting setup, crash excel
recalculating the pivot.
If you create a pivot, and then you try to sort the result, excel crashes.
This happen after last update 12.1.1.
.
- Follow-Ups:
- Re: Pivot Table sort by count of crashes 2008 but not 2004
- From: Fred Hopley
- Re: Pivot Table sort by count of crashes 2008 but not 2004
- References:
- Prev by Date: excel 2004 - adjust position of x-axis values
- Next by Date: data filtering
- Previous by thread: Re: Pivot Table sort by count of crashes 2008 but not 2004
- Next by thread: Re: Pivot Table sort by count of crashes 2008 but not 2004
- Index(es):
Relevant Pages
|
