1 of 1 people found this helpful
Are you running 32-bit or 64-bit Excel?
If you are running 32-bit I find it likely that Excel is consuming more than 1024MB of memory when you are doing changes and therefor crashes.
Very likely this ^
The event viewer (application) should give you some more insight on the reason of the crash as well.
I agree with both Gab and Andre. Look for an Out of Memory exception in the logs of the application crash.
If this isn't the issue, can you tell us the version and bitness of Excel and the provider?