General discussion
November 26, 2006 at 08:45 PM
jrobertson

Excel 2003 Workbook Sharing

by jrobertson . Updated 19 years, 10 months ago

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.

This discussion is locked

All Comments