Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Why do I get "Synchronization with the data source failed" when trying to use an Excel spreadsheet as a data source?

Why do I get "Synchronization with the data source failed" when trying to use an Excel spreadsheet as a data source?

Problem:

Why do I get "Synchronization with the data source failed" when trying to use an Excel spreadsheet as a data source?

Resolution:

One reason for this problem arises when you enter numbers in a column where the cells are formatted either as General or Numeric and you then change the cell format to Text.

The behaviour of Excel with numbers in text columns is very inconsistent. Changing the cell format for existing numbers seems to result in a different behaviour than when entering a number into a cell that is already text formatted. In the second case you get the little green triangle in the left upper corner of the cell and the warning that "The number in this cell is formatted as text or preceded by an apostrophe". Those cells with the warning shown are imported as string values. The ones without the warning are regarded as numbers, although the cell format is text. Entering the values in already text formatted cells should fix the format issue i.e. make the numbers appear as strings.

A second solution is to pre-pend all data with an apostrophe, thus forcing both SilkCentral and Excel to treat the data as a string.


Old KB# 25107

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Top Contributors
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 19:52
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.