Hi,

I've written a routine in VB.NET to import an excel spreadsheet. This has been working fine and is now tried and tested.

However, when we tried to import one particular spreadsheet (which includes complex formulas etc.) the process hangs on Workbook.Load

Dim dataWorkbook As Workbook

Dim s As IO.Stream = New IO.MemoryStream(bSpreadsheetFile)

dataWorkbook = Workbook.Load(s)

It hangs on that last line. (bSpreadsheetFile is a byte array containing the spreadsheet)

I've uploaded ths spreadsheet onto FileDropper

http://www.filedropper.com/jimimport-crashesjobqueue

<a href=http://www.filedropper.com/jimimport-crashesjobqueue><img src=http://www.filedropper.com/download_button.png width=127 height=145 border=0/></a><br /><div style=font-size:9px;font-family:Arial, Helvetica, sans-serif;width:127px;font-color:#44a854;> <a href=http://www.filedropper.com >file storage</a></div>

The excel refernce on the server project is 'InfragisticsWPF4.Documents.Excel.v12.2'

Hope you can help

Many thanks

Andy