Workshare offers robust solutions for comparing Excel documents, ensuring accuracy and efficiency in identifying differences between spreadsheets. Whether you’re using Workshare Professional 10 or an older version like Workshare 9, there are options available to streamline your comparison process.
Workshare Professional 10: Advanced Excel Comparison
Workshare Professional 10 boasts advanced Excel comparison capabilities, allowing users to quickly and easily pinpoint changes between two spreadsheets. Key features include:
- Color-Coded Highlighting: Visualize changes at a glance with color-coded highlighting, providing a clear overview of modifications.
- Detailed Change Tracking: Clearly identifies changes in cell values, including numbers, text, and formulas.
- Customizable Filters: Focus on specific types of changes, such as formula modifications, number adjustments, text alterations, or font changes, using customizable filters.
- In-Depth Cell Analysis: Dive deep into individual cells to examine the specifics of each change made. This granular level of detail allows for a thorough understanding of revisions.
Workshare 9 and 9.5: Integration with Microsoft Spreadsheet Compare
For users of Workshare 9 and 9.5, integration with Microsoft’s Spreadsheet Compare tool offers a basic comparison solution. This functionality is included in Office Professional Plus 2013, Office Professional Plus 2016, and Office 365 ProPlus.
Enabling the Integration:
Administrators can enable a right-click comparison option for users by deploying a specific REG key. Refer to the Workshare knowledge base for detailed instructions and access to the necessary REG keys.
Creating a Shortcut:
A shortcut for convenient access can be created by navigating to the Workshare Modules folder (typically found in “C:Program FilesWorkshareModules” for 32-bit Windows or “C:Program Files (x86)WorkshareModules” for 64-bit Windows), right-clicking “Workshare.Excel.Comparer.exe,” and selecting “Create shortcut.”
Running a Comparison:
Once enabled, simply right-click on one or two Excel spreadsheets in Windows Explorer or your document management system and select “Compare via Workshare.” A dialog box will guide you through the comparison process.
Note: As Spreadsheet Compare is a Microsoft product, support is provided by Microsoft, not Workshare.
Conclusion: Streamlining Excel Comparisons with Workshare
Workshare provides effective solutions for comparing Excel documents, ranging from advanced features in Workshare Professional 10 to integration with Microsoft Spreadsheet Compare in earlier versions. By leveraging these capabilities, users can ensure accuracy, save time, and gain valuable insights into spreadsheet revisions. Choose the solution that best fits your needs and experience the efficiency of streamlined Excel comparisons.
