The Books tab in the Tools | Spreadsheet Options dialog lets you control the default behaviour of workbooks, such as opening large workbooks as read-only, or warning you if the book you are opening has column names that are duplicated in another open book. You can find a full description of all the options here.
