Latest Changes

Below is a summary of recent updates, including new features, usability improvements, and bug fixes for both Windows and Mac versions of Excel.

If you have a feature request or encounter an issue, feedback is always welcome and often directly influences future updates.

VersionChange SummaryWindowsMacChange Type
1.070Updated default UI styling for various forms (White theme). Browse/Find form sync with data form and worksheet enabled by default)YesYesUI / UX
1.070Pressing F9 prints the form with the current record to the default printer (Mac: Fn + F9)YesYesNew Feature
1.070Detects external changes to the current record while a form is openYesYesNew Feature
1.070EZ Filter now supports Advanced Filter output directly to a user-selected worksheet (alternative to in-place filtering)YesYesNew Feature
1.070Improved support for co-authored workbooks: AutoExcelForms detects when another user or process modifies the same record, warns the user, temporarily disables edits or deletion, reloads the latest data, and then allows editing to continueYesYesNew Feature
1.070Lookup return field now respects the user-selected column: previously it always returned column 1 from the lookup table; it now returns the column chosen in the “Customise Columns” setup formYesYesBug Fix
1.070Fixed sporadic “Method Range of object _Worksheet not found” errorYesYesBug Fix

Many of the enhancements listed above were driven by customer feedback.
AutoExcelForms continues to evolve to support more advanced Excel workflows while remaining simple to use.