Re: Pivot Table sort by count of crashes 2008 but not 2004

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.











.

Relevant Pages

  • Re: Pivot Table sort by count of crashes 2008 but not 2004
    ... I then perform a pivot table report and do a sort on one of the columns. ... descending on the count of that column, Excel 08 always crashes. ...
    (microsoft.public.mac.office.excel)
  • Re: Pivot Table sort by count of crashes 2008 but not 2004
    ... I then perform a pivot table report and do a sort on one of the columns. ... descending on the count of that column, Excel 08 always crashes. ...
    (microsoft.public.mac.office.excel)
  • How to stop pivot table crashing in Excel 2007
    ... crashing while making a pivot table after a specific series of events happen. ... If I do this excel crashes: ... populated by a formula such as 1st of the month date formula excel crashes. ... If I leave the chart on the same tab as the pivot table there is no crashing ...
    (microsoft.public.excel.charting)
  • Re: using DSUM in formulae instead of SUMIF
    ... Or, set up a pivot table, with Rep in the page area. ... > Is it possible to somehow sort as the above example illustrates, ... I am very new at Excel programming, ... Will the SUMIF function accept IF types of arguments ...
    (microsoft.public.excel.worksheet.functions)
  • Re: SORTING question
    ... I'm just going to pass along some general (Excel) sorting advice. ... When you tell Excel to sort, you can do so in several ways. ... > about having the original order disrupted because occasionally I will have ...
    (microsoft.public.excel.newusers)