Dick M has a great post here about the pain and fragility of user maintained spreadsheets/systems.
I think many of us have been in that situation. I have had to twist Excel to do things because clients do not want the maintenance hassle of VBA. (But they feel happy to maintain millions of cells of complex interrelated formulas).
But I wonder if the real issue is just crap, or non-existent change control? If the client had a test environment and tested before release would that make most of the user maintenance misery go away?
A test environment, or even a test mentality does not have to be difficult. But I sure don’t see it much in End User Computing. Do you?