Advanced Filters cause Excel crash

Does anyone have the fix to the problem that,
intermittently, Excel (all versions) crashes when you try
to use an advanced filter.

In a room of machines, all using an identical starting
spreadsheet, one or more of them may crash when trying to
implement a very simple advanced filter.

Any solutions?