Small enterprises that depend on desktop applications such as Microsoft Excel are already leaving themselves vulnerable to human error typically caused by overextension of Office tools. Today, Microsoft Office 2007 compatibility issues cause additional concerns over the integrity of spreadsheet data in Excel. These problems range from blank data caused by formatting errors to distorted data as a result of formula incompatibility with previous versions of Excel.
This report covers three topics:
- Data integrity issues in Microsoft Excel.
- Working in Microsoft compatibility mode.
- Optimizing use of Excel over multiple versions.
Small enterprises relying heavily on Excel must establish standards to secure the integrity of Excel spreadsheet data.