Decision Models - What's New

Build 484 of FastExcel with build 602 of Name Manager

Build 483 of FastExcel with build 601 of Name Manager

Multi-area UDF bug partially fixed in Excel 2003 and fully fixed in Excel 2007

Revised Outlines for my sessions at the Australian Excel User Conference

Using a row height of 0.1 slows down calculation

Build 480 of FastExcel

Build 594 of Name Manager

A History of the Heyder Family

FastExcel 2.3 Build 479 with Name manager 4.1 Build 592

FastExcel 2.3 Build 478 with Name manager 4.1 Build 592

Variant Benchmark Download & comment on Google Desktop slowdown

FastExcel 2.3 Build 475

Updated description of Memory Useage with Excel 2003 and Excel 2007.

FastExcel 2.3 build 472 with Name Manager build 582

FastExcel 2.3 Build 471 with Name manager build 582

Added comments on Automation Addins and Range.Value2 to the UDF page.

Updated description of Sheet.Calculate in Manual mode, Range.dirty and Application.Checkabort

Name Manager 4.0 and Name Manager 2007 Build 580

FastExcel 2.3 Build 469 with Name Manager Build 580

Name Manager 4.0 and Name Manager 2007 Build 578

Updated description of Application.Checkabort and Range.CalculateRowMajorOrder

'Improving Performance in Excel2007' published on MSDN

FastExcel 2.3 Build 468 available

Name Manager 4.0 build 574 available

FastExcel 2.3 Build 467 available

FastExcel 2.3 Build 466 available

FastExcel 2.3 Build 465 available

Name Manager 4.0 build 565 available

UK Excel Users Conference July 19-20

Revised version of AddinLoader

Revisions to a number of Optimising speed pages.

Conditional formats are volatile

Build 457 of FastExcel now available

Update to Excel's dependency limits (Calculate in Status Bar)

Excel 12 Memory limits

Build 456 of FastExcel now available

Build 532 of Name Manager now available

Excel 2002 and 2003 Range.calculate can give different results to Excel 97 and 2000

Blessig Family History

Google Desktop bug causes FastExcel problems

Build 452 of FastExcel

Updated Application.Evaluate limitations.

Name Manager 3.2 (build 530) now availabale

Downloadable Counting Functions: run-time functions for the FastExcel Dynamic Range Wizard

Revised the description of how Application.Evaluate works.

Build 446 of FastExcel

Revised FastExcel Version 2 Sample Problem

Build 444 of FastExcel

Build 483 of Name Manager 3.1

2 September 2004

Version 2.1 of FastExcel

The official memory limit for Excel 2003 is 1 Gigabyte (1024MB)

Excel 2003 flags rows as uncalculated when hiding or unhiding.

Explanation of Circular Reference calculation sequence and optimisation of speed.

Build 478 of Name Manager 3.1

SUMPRODUCT performance compared to array formulae.

Linked pictures cause slow calculation and VBA.

Name Manager Version 3.1 build 477

Slow calculation of UDFs in automatic mode and with the VBE open

Build 470 of Name Manager Version 3.0

Special Offer on FastExcel V2

Added EVAL function example to Calculating from VBA page

Partial fix for Netscape 7 users: use page up and page down to scroll

Name Manager Version 3.0 (build 467) now available

Added description of Autofilter effect to Volatile Actions and Evaluation Circumstances

Beta 2 version of Name Manager Version 3.0 (build 446) now available

Revised version of MakeInterlinkedSheets memory tester.

Beta version of Name Manager Version 3.0 (build 442) now available

FastExcel Version 2 now available (Build 436).

Added information on Excel 2003 memory limits.

FastExcel Version 2 Beta 3 build 435

Added description of using EnableCalculation for FullCalculate and Full sheet calculate.

Updated Lookups page for threedimensional and lookups with more than one answer.

FastExcel Version 2 Beta 3 build 433 available for testing to all FastExcel V1 License holders.

Updated several Calcsecrets pages and the calculation bottlenecks page with information on calculating names.

Updated the behaviour of Range.calculate with Excel 2002

Added site search facility.

Name Manager Version 2.3 build 410 now available from downloads.

Updated the descriptions of EnableCalculation and RangeCalculate

Build 396 of Name Manager 2.2

Explanation of the difference between Application.Evaluate and Worksheet.Evaluate

Downloadable workbook demonstrating interlinked sheets Memory useage and limits.

Build 378 of Name Manager

Example of the Multi-Area UDF argument bug, and a bypass added to the downloads page.

Name Manager Version 2.2 now available on the downloads page.

Added Areas Bug warning to UDF page, revised list of volatile functions(tested), revised Controlling Calculation page.

Revised the Controlling Calculation from VBA and Memory limits pages.

Revised the Bottlenecks, Calculation Process, Dependency Trees and Calculations Methods pages.

Revised the Memory, Memory limits and Leaks pages.

Version 1.3 (Build 71) of FastExcel

Version 2 of the Add-in Loader

Array Functions, Function Wizard, Improved/more examples on the User Defined Functions page.

Added explanation of Calculation at Open to the Controlling Calculation page.

Revised User Defined Function Page, False Dependencies and Uncalculated Cells

Removed HTML Scrollbars

Added RangeCalc addin to the Downloads Page

Revised Bottlenecks Page to include slow opening/closing problems.

Revised Calculation Secrets pages.

Version 1.2 (Build 68) of FastExcel, Expanded descriptions in the Sample Problem

Revised FastExcel Sample problem. Downloadable FastExcel User Manual.

Site now supports Netscape 4.7 and 6.0

Extended descriptions of using VBA to control Calculation methods properties and events.

Version 1.1 (Build 64) of FastExcel

Added FastExcel Support Page

Site goes live.