Excel 1908 causing error in tools using the spreadsheet as an input

%3CLINGO-SUB%20id%3D%22lingo-sub-1609005%22%20slang%3D%22en-US%22%3EExcel%201908%20causing%20error%20in%20tools%20using%20the%20spreadsheet%20as%20an%20input%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1609005%22%20slang%3D%22en-US%22%3E%3CP%3EWith%20version%201908%20of%20excel%2C%20errors%20are%20occurring%20in%20Showcase%2C%20Alteryx%2C%20IBMi%20Data%20Transfer%20tool%20and%20SystemLink%20uploads%20when%20excel%20is%20used%20as%20an%20input%20and%20has%20a%20column%20of%20data%20which%20begins%20with%20zeros%20(either%20formatted%20as%20general%2C%20text%20or%20number).%26nbsp%3B%20This%20happens%20even%20if%20the%20error%2Fwarning%20on%20the%20cell%2Fcolumn%20has%20been%20ignored%20(where%20a%20triangle%20shows%20in%20the%20upper%20left%20of%20the%20cell).%26nbsp%3B%20I%20also%20followed%20methods%202%20and%204%20on%20this%20link%20to%20try%20to%20resolve%20this%2C%20but%20still%20get%20the%20same%20errors%20in%20those%20tools.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F5872-excel-start-number-with-zero.html%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.extendoffice.com%2Fdocuments%2Fexcel%2F5872-excel-start-number-with-zero.html%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBefore%20updating%20to%20version%201908%2C%20I%20didn't%20have%20this%20issue%20with%20those%20tools.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1610215%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%201908%20causing%20error%20in%20tools%20using%20the%20spreadsheet%20as%20an%20input%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610215%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F769499%22%20target%3D%22_blank%22%3E%40ShellyBowles%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20please%20share%20the%20screenshot%20of%20the%20error%20and%20what%20format%20are%20trying%20to%20upload.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%20please%20share%20us%20the%20few%20sample%20records%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%2FBest%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1610688%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%201908%20causing%20error%20in%20tools%20using%20the%20spreadsheet%20as%20an%20input%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1610688%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20responding.%26nbsp%3B%20Interestingly%20enough%2C%20some%20MS%20patches%20were%20installed%20on%20my%20laptop%20yesterday.%26nbsp%3B%20Since%20then%2C%20two%20of%20the%20errors%20I%20experienced%20have%20been%20resolved.%26nbsp%3B%20I've%20asked%20the%20IT%20team%20for%20details%20about%20which%20patches%20were%20installed%2C%20so%20I%20can%20see%20if%20that%20info%20will%20help%20resolve%20the%20issue%20with%20the%20other%20two%20tools.%26nbsp%3B%20I'll%20provide%20more%20details%20(screenshots%2C%20data%20samples)%20once%20I%20have%20more%20info.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers.%3C%2FP%3E%3CP%3EShelly%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

With version 1908 of excel, errors are occurring in Showcase, Alteryx, IBMi Data Transfer tool and SystemLink uploads when excel is used as an input and has a column of data which begins with zeros (either formatted as general, text or number).  This happens even if the error/warning on the cell/column has been ignored (where a triangle shows in the upper left of the cell).  I also followed methods 2 and 4 on this link to try to resolve this, but still get the same errors in those tools. 

https://www.extendoffice.com/documents/excel/5872-excel-start-number-with-zero.html

 

Before updating to version 1908, I didn't have this issue with those tools.

2 Replies

Hi @ShellyBowles 

 

Can you please share the screenshot of the error and what format are trying to upload.

 

Also please share us the few sample records 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more

Hello, @Faraz Shaikh.  

 

Thank you for responding.  Interestingly enough, some MS patches were installed on my laptop yesterday.  Since then, two of the errors I experienced have been resolved.  I've asked the IT team for details about which patches were installed, so I can see if that info will help resolve the issue with the other two tools.  I'll provide more details (screenshots, data samples) once I have more info.

 

Cheers.

Shelly