Hi All,

Not sure which thread to post this under so I figured General would be best.

I have an excel file with locked formulas that is used by a large group of people, so unfortunately allowing the deletion of rows will not work-there are other formulas on each line. The file type is: Microsoft Excel 97-2003 Worksheet (.xls). The first column (A) pulls a formula as follows: =IF(OR('Analyst Worksheets'!H35="Yes",'Analyst Worksheets'!H35="No",NOT(F5="Acceptable")),'Analyst Worksheets'!B1&"-"&'Analyst Worksheets'!C1,"") so on and so forth, there are specific numbers it is pulling from for each cell. The issue I am having is when I go to import the file. When a cell is coming back blank, i.e. "", I am getting an error on import which states:

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Exception: Order has not been created
at EHS.Component.WFDataImport.SaveImportedData(Int32 WFListeningPointID, Int32 WFFormatID, Byte[] arrBytes, String fileName)
at WFLIMSService.LIMSInterface.SaveImportedBinaryFileData(Int32 WFListeningPointID, Int32 WFFormatID, Byte[] arrBytes, String fileName)
--- End of inner exception stack trace ---

Following the error, no more data will import to the system. I can not use a macro as there are too many people using this file and a macro enabled file will not import to the system we are using. What can I do to get around this problem/have Excel ignore the "" Order and keep searching for the next one?

Thanks for any help you can provide!