Microsoft Excel is one of the most commonly used tools for reporting, analysis and "what if" scenarios, with over 250 million users worldwide. The drawback so many users and different solutions is that the resulting spreadsheet reports typically lack visual formatting such as the formulas, wording, etc.

This paper will discuss the different steps involved in the process of formatting and changing between different documents and by learning this we can develop a clear understanding of the technical requirements for an automated solution. This paper will also introduces a solution for automating the generation and secure distribution of spreadsheet reports making it easier on all users.