Re: Excel 2003 Pivot Crash

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Final resolution: In this Networked environment where I do not have admin
rights under the XP operating system, it took an install of system updates by
an authorized administrator to resolve the problem permanently. I can't even
guess which updates in the past threw this off nor which updates today put it
back in order.

"Klatu''s_wife" wrote:

None of the above links have anything applicable to this situation. I did,
however pursue this all morning and have figured out a work-around. If I
open two instances of Excel then open up any old file in the first instance,
then make absolutely certain I click into the SECOND instance before I open
the file I wish to pivot, nothing bad happens. The file does not crash when
I format the pivot report and save it. Also, I have ask our desktop support
to uninstall Excel and reinstall it. When that is accomplished, I'll post
back to let y'all know if that solves the problem without the work-around.

"Debra Dalgleish" wrote:

There are a few ideas here that may help you:


http://www.wiredbox.net/Forum/Thread41490_Pivot_Table_Integrity_Problems.aspx

Klatu''s_wife wrote:
I don't think so, totally different problem. I have the file open and it
crashed upon saving it, performs the repair, then shuts down.

"Debra Dalgleish" wrote:


The information in the following MSKB article may help.

XL2002: "Unable to Read File" Error Message When You Open Excel File
That Contains a PivotTable Report

http://support.microsoft.com/default.aspx?kbid=819853

Klatu''s_wife wrote:

Additional information: After the forced close began, the following was
reported to me: Microsoft Office Excel File Repair Log

Errors were detected in file 'C:\Documents and Settings\VSJM3\Application
Data\Microsoft\Excel\L46901_VSJM3_Item_4330 dept 969 MTD 4.28.07 to 5.12.07
(version 1).xls'
The following is a list of repairs:

Global PivotTable report information was repaired due to integrity problems.

So am wondering what is wrong with the installation that Excel would write
it's own Integrity problems.

Is there an MVP out there?

"Klatu's_wife" wrote:



I have Excel 2003 on XP platform and within the past month or so have been
having problems with Excel crashing every time I assign a report format to a
pivot table. I am prevented from formating my pivot report. Anyone have
this problem or know of a fix?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html


.

Relevant Pages

  • Re: why>?
    ... Just because PDF is more popular than SNP; ... Emailing a dynamic report is easier than emailing PDF files.. ... Excel is ALWAYS less efficient than Access. ... e) multi-user functionality - being able to work on the same report / ...
    (microsoft.public.excel)
  • Re: Excel 2003 Pivot Crash
    ... I format the pivot report and save it. ... to uninstall Excel and reinstall it. ... "Debra Dalgleish" wrote: ... crashed upon saving it, performs the repair, then shuts down. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Need Resource Group in Visual Reports
    ... Because the machine I use with Project 2007 doesn't have Excel 2003 ... showing the same information as the Visual Report in Excel. ... When you said:"I've saved the resource usage cube and transferred ...
    (microsoft.public.project)
  • Re: BCWP and BCWS
    ... Were you able to add the Tasks to Row labels in Excel? ... Report Filter, add to ROW Labels and Add to Column Labels. ... editing the report and inserting Actual Costs, Tacks AC, Task ... calculates actual duration and remaining duration. ...
    (microsoft.public.project)
  • RE: Get parameter dates in heading
    ... sheet but it creats a new report and the alignment gets all messed up ... It actuall creates a new Excel spreadsheet. ... Dim varGetFileName As Variant 'File Name with Full Path ... Dim strLeftRange As String 'Used to format range references ...
    (microsoft.public.access.externaldata)