J-Walk & Associates, Inc.

ForceFullCalculation Oddity Posted

I posted a new item in the Oddities section about a new property in Excel 2007 called ForceFullCalculation. Maybe somebody knows what it's good for, but one thing is certain: Something Gets Forced.

The first thing I noticed is that when you set this property in a workbook, it causes the status bar Calculate indicator to stay on permanently. The only way to get rid of that indicator is to restart Excel.

Any clues about why this setting might be useful?

- Reader Comments -

Following are comments in response to this item.
The most recent comment is at the bottom.

1. By sam. Comment posted 07 September, 2008 10:03pm

   Another Oddity....
   
   Turn on the Macro Recorder... and Click on Insert -> Diagram (Excel 2003)....Gives an Error ...."You must Select a Shape" and some times there is no error...but in eiter case does not let you insert a Diagram
   
   
   Sam
2. By Scott. Comment posted 09 September, 2008 5:33am

   Here's another oddity maybe somebody can answer for me: why is it, when using an autofilter, sometimes the number of filtered records appears in the statusbar, and other times it does not?
3. By John Walkenbach. Comment posted 09 September, 2008 5:44am

   Scott, see:
   
   http://support.microsoft.com/kb/213886
4. By Scott. Comment posted 09 September, 2008 12:07pm

   Well, how about that? All my searching and I never found that article.
   
   Thanks for the info!