AnsweredAssumed Answered

Excel 2007 & Design Table Crashes

Question asked by M. B. on Jun 19, 2013

Using SW2011 SP1, Win7 64bit, MS Office Professional 2007.

 

Just spent 2 days dealing with design table crashes, freeze ups, and a corrupted .sldprt file that would not open unless I went to the backups and opened an older version.  I found out by accident today that one of the crashing issues (there are others) was related to the $ absolute reference character in Excel 2007.

 

Reference G36 would work without crashing

Reference G$36 would either crash or the configurations using this reference would not change or update. 

 

Out of hundreds of cells with complex formulas only a few had the absolute $ and when I removed them, things immediately got better so its definitely related to the absolute reference.

 

In a recent thread someone thought the July Microsoft updates caused similar problems.  The poster said that they uninstalled one of the updates and the problem was solved.  I can't find that thread but would very much like to read it again.

 

I have always had occasional design table crashes but lately its become almost impossible to get any work done.  Does anyone know what is going on and how to fix it?

 

Thanks.

Outcomes