Error reading macro-excel(xlsm) file having formula cells in it

[Anonymous]

Hi,

I am using custom components(tfileexcelworkbookopen-->tfileExcelSheetList-->tfileExcelSheetInput) to read a xlsm file.

It is giving the following error : "java.lang.Exception:Read column Inventory_Date in row number=1 failedpecified named range 'WM_TableFormID' does not exist in the current workbook. ".

The problem is it is reading the cell's formula instead of reading the real data.

Please suggest.

Thanks

skp