FAQs

What 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
  • Navigator
    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.


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. 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.


Restrictions
 
  • 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 costs

There are three different editions of Synkronizer 10.0 available. These editions contain the following

Professional
Edition 		Developer
Edition
 Evaluation
Edition *
Highlight differences • • •
Create a difference report • • •
Navigator form • • •
Synkronizer VBA •
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!

Because Synkronizer

  • 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