In my work I normally create import queries to collect data from a constantly updated textfile. I have the problem that whenever I modify the connection properties, e.g. the refresh rate for collecting external data or the name of the file to collect from, Excel 2007 crashes when I am affirming the modification. However autorecovery comes up with the new changes. This is starting to annoy me.
Has anyone ever experienced this before? If you have any idea how to solve this problem please let me know.