Spy Journal 3.0 Filtering the web for you

Dick Kusleika writes:

The Excel object model provides the Application.CalculationInterruptKey property to control how/if calculation can be interrupted. xlAnyKey is the default and it pauses whenever the user starts working. xlEscKey only pauses when the escape key is pressed. It’s used when you want to allow the user to interrupt calculation, but you want to make sure they do it explicitly and not by accident. xlNoKey prevents interruption. It seems that any time you calculate in code, you should set this property to xlNoKey, then set it back.

Full article here

My stats for June. Not quite as good as J-Walks – though my bounce rate is better!

Joseph Chirilov has written a series of 3 posts showing exactly how to build a fully functioning media player inside Excel.

If you want to try this then follow his step 1, step 2 and step 3. I would be interested in hearing from anybody who does that.

While we are talking about Joseph's site I want to highlight two other posts that are there.

David Gainer posted this article on his blog with the corrections for the Excel 2007 Calculation error we wrote about recently.

Two weeks ago, we posted about an issue involving the calculation of numbers around 65,535 and 65,536. As of today, fixes for this issue in Excel 2007 and Excel Services 2007 are available for download from the following locations:
Excel 2007
64-bit Excel Services 2007
32-bit Excel Services 2007

Yesterday evening as I was about to go to bed one of my developers Doug, sent through a link to a forum post outlining a serious calculation error in Excel 2007.

This afternoon David Gainer, in the Excel team, posted an official response to the Excel 2007 Calculation Error.
He outlines the background to the problem, the specific issue in Excel 2007 and the solution.

It looks like it will be 10-15 days before a patch is distributed.

I will keep you all updated.