FAQsWhat is Synkronizer
Synkronizer is a COM add-in that compares, synchronizes and updates Excel spreadsheets.
How does Synkronizer work
Synkronizer reads the data from the old and new Excel sheets and compares bit by bit each cell entry. Synkronizer has a verifying tool that detects all differences automatically. This enables you to immediately determine the data added, deleted or changed. Furthermore Synkronizer is a database-tool that adjusts and synchronizes Excel databases.
What functions does Synkronizer perform
Synkronizer performs the following functions:
- highlights the differences in the underlying spreadsheets
- creates a difference report
With the navigator option you can adapt your Excel files. By using a user-friendly tool you can easily navigate through the differences by examining or adapting them. With this option you verify that your data is always updated.
Synkronizer 10.0 works with Excel 2002 (XP), Excel 2003, Excel 2007 and Excel 2010, 32 bit mode. Excel 2010, 64 bit mode, is not supported. The 64 bit version of Synkronizer will be eleased in Spring 2013.
What is a COM Add-In
A COM Add-In is an additional program, procedure or function, that is loaded automatically when Excel (or another application) is started. An add-In addresses the needs of different users and increases the comfort and speed factor when working with such applications.
How do I get the best comparing results
Synkronizer achieves the best comparing results when your Excel sheets contain a database structure. In other words, your sheets must have unique column headings and primary keys. The advantage of a database structure is that you can delete or add any row/columns within your Excel sheets. You can also sort the data. Synkronizer detects all differences immediately.
What is a primary key
The database has one column with primary keys (unique identification number, article number etc.). A primary key identifies the data records and facilitates the sorting and synchronizing of your data. The primary key does not necessary need to be a single column, it can also be formed from two or three columns (e.g. family name, first name and city). Disadvantage of multiple column primary keys: duplicated primary keys may occur.
What are duplicated primary keys
Duplicated primary keys are data records that contain the same identification number. Assuming the primary key is formed from the family and first name, if you have several customers called "John Miller" in your database, Synkronizer does not know which data records are to be compared. Make sure that you always operate with unique primary keys.
- Synkronizer compares cell contents or formulas. Diagrams, objects and Visual Basic modules are not compared
- Synkronizer does not support Macintosh-operating-systems
What Synkronizer contains and how much it costsThere are three different editions of Synkronizer 10.0 available. These editions contain the following
|Create a difference report||•||•||•|
|Price (Single PC license)||EUR 79.00||EUR 149.00||free *|
* The evaluation edition compares only a limited range (A1:Z100)
Have you ever worked with an outdated Excel-sheet?
With Synkronizer never again - guaranteed!
- performs an automatic comparison of two Excel sheets and guarantees that the correct version is used
- detects and lists immediately unintended modifications that have occurred in your Excel sheets
- simplifies the process control of your work by means of a difference report that informs you about the finished and in-process jobs
- saves you valuable time and money. Working with outdated Excel sheets and laborious and lengthy comparing hours are things of the past
Is the comparison of your Excel-database too difficult and time-consuming? With Synkronizer never again - guaranteed!Because Synkronizer
- compares complex Excel-database
- compares Excel databases with a different sorting order
- compares Excel tables, even if data records or column headings have been deleted or added within the underlying tables