I was after general opinions about using the Shared workbook feature within Excel 2003. We are looking at using it so that people can be editing a spreadsheet, but also import the data via SQL2005.
I have had the experience where the workbook is shared and open; the SQL is currently accessing the data within the spreadsheet; save is hit within Excel and Excel then crashes quite horribly, not allowing an auto recover file and turning off the auto save feature. This occured approx 85% of the time.
Any opinions would greatly appreciated.