Some other suggestions for building spreadsheet models that are robust, flexible and have a reduced risk of errors.
Avoid multiple workbooks
Using multiple workbooks adds risk. Where at all possible combine workbooks into one workbook (the CUT AND PASTE function is useful for this). If this is not practical it is vital that all linked workbooks are open as they are being used and everyone should know about the risk shown in the video clip below.
To see the full course contents click here.