PivotChart does not allow opening another spreadsheet

N

notesangern

Whenever I relocate a PivotChart to the worksheet that contains the
PivotTable data for it, it seems to corrupt Excel so that I am unable to open
another spreadsheet. It restarts Excel with the message asking if I want to
send a report to Microsoft, I click "No", then it proceeds to do the exact
same thing again, the error recurs and Excel restarts, until finally, it
"repairs" the sheet with the PivotChart except everything has been Flat-filed
with no formatting whatsoever.

This is very annoying - why is this occuring, what is the issue, how can I
fix/avoid this from occuring?
 
N

notesangern

My mistake - I meant to say that whenever I have another spreadsheet open, I
cannot open a different spreadsheet that contains a PivotChart that's on the
same worksheet as the PivotTable without the below error occuring. That is
the problem. Does anyone experience the same issue?
 
Top