|Title||Spreadsheet safety: Designing the perfect file|
|Authors||Jennifer Kreie & John Pendley|
|Publication||Journal of Accountancy|
|Series||Volume 186, Number 5, November, pages 31-34|
In recent years, spreadsheets have taken on a role far more important than they had in the pre-computer days: shaping business strategies and being used increasingly for ongoing projects by many different people who need to go in and out of a file, to add material and even to customize the output for their specific needs.
This presents a new challenge for the spreadsheet developer, who must design the file so it cannot be accidentally altered by an inexperienced user.
Here are steps to ensure safe spreadsheet design:
The documentation module includes detailed explanations about the application. It may contain specific clarifications such as data format, identity of protected cells, special printing instructions or any other important information the developer wants to include.