select worksheets are corrupting/freezing

[J_Anderson]

Background situation: I am working with a file that contains around 15
PivotTables, all linked to the same cache.

The problem: For about a week I have been having trouble with a few of
the worksheets - about 3 different tabs, each contains a chart. The
file opens fine, no error messages, but when I click on one of the
problematic worksheets and then try to change anything on it - close
the field list, move the chart, or even select and move to a different
worksheet, Excel begins to freeze, and portions of the screen are
frozen to the image of the problematic worksheet. I even tried moving
all of the healthy worksheets to a new file, then creating the
problematic pages from scratch, and yet am still having the problem.

Mild Success: If I open the file within Excel, by selecting "repair
and open" from the drop-down menu in the "open" wizard, it works fine.


Question: Does anyone have any knowledge of what is happening here,
and/or how to actually fix it, rather than repairing the file every
time I open it or having to build a new one from scratch?

Thanks!