Excel 2007 "microsoft has encountered a problem...unexpected closes..

[Carl]

This is my first post

Running dual processor w 4 GB memory. Windows XP (3.2 GB) up to date
with patches and SP's. Office 2007 professional with SP1.

Pivot table drops the above message when trying to pivot time and
groups of dollars.
Base data table 44,000 lines and pivot table has 10 sort columns and
12 time columns and there are six values for each row.

Data
1 2 3
4 ..........Total
Descriptive Variables (8) Amount1
Amount2
Amount6

It will handle the table if I only include four of the six values row.
The pivot table has 22 columns (10 data) and only 2400 rows when
summarized.

I have tried a bunch of things.
New new workbook spreadsheet not copied from the old with all new
pivot table from scratch. Tried multiple formats for saving and
starting. I have repaired excel once. And I have gotten it to run a
345,000 line data set with a pivot table.

I have looked for examples of others having this problem but I have
not found one close.

Any suggestions would be appreciated

 

[Ketan]

I too am having the same problem with Excel 2007 and my dataset is not nearly
as large. I have 2 data fields (hours and dollars) to report on how much
each employee is charging against the budget. I drop the "hours" field in
with no problem. As soon as I drop in the "amount" field also, it starts to
calculate and then crashes. Then it asks me if I want to recover the
document and restart Excel. I choose yes, but upon restart, it calculates
again and crashes again...it does that perpetually and doesn't stop unless I
tell it not to recover & restart at which point I lose the work I did up till
the actual calculation.

This is the exact same report that I have been running on Excel 2003 for
years without any problem, so it's really annoying to have it appear after
the upgrade. Thanks in advance for any help.