FAQs
What is SynkronizerSynkronizer is an Excel 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
- Navigator
With the navigator option you can adapt your Excel files. By using a user-friendly tool bar you can easily navigate through the differences by examining or adapting them. With this option you verify that your data is always updated
System requirements
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 yet.
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 will not know which data records are to be compared. Make sure that you always operate with unique primary keys
What Synkronizer contains and how much it costs
There are two different editions of Synkronizer 10.0 available. These editions contain the following
|
Professional
Edition
|
Developer
Edition
|
Evaluation
Edition *
|
|
| Full Access |
• | • | |
| Highlight Differences | • | • | • |
| Create Difference Report | • | • | • |
| Navigator | • | • | • |
| Synkronizer VBA |
• | ||
| Price | EUR 79.-- | EUR 149.-- | free |
* the Evaluation edition compares only a limited range (A1:Z100) of the spreadsheets/databases