With Spreadsheet Interpreter set to RealTime Analytics, hitting Simulate produces an "Unexpected behavior encountered" error. Details below. I performed the work-around of changing Spreadsheet Interpreter to Native Excel, and the simulation will run. Now after saving the model and reopening, all the embedded Charts and Tables have VALUE errors. Not sure if the two are related. Going to check #4 Mysterious VALUE next. Also, while not (yet) running Office 365, I'm running into a similar issue to #30 where I have to reload Argo every time I open Excel. Ironically, the VALUE errors only seem to appear after I load Argo.
at Microsoft.Office.Interop.Excel._Application.get_Range(Object Cell1, Object Cell2)
at ArgoXllDev.ExcelAddressUtil.ParsePositionInfo(String arg, IntPtr defaultsheetid, Int32& r1, Int32& r2, Int32& c1, Int32& c2, String& workbook, String& worksheet)
at ArgoXllDev.PrecedentMiner.BuildPrecedentChain()
at ArgoXllDev.RegisterUDFLib.__Argo_BuildPrecedents__()
With Spreadsheet Interpreter set to RealTime Analytics, hitting Simulate produces an "Unexpected behavior encountered" error. Details below. I performed the work-around of changing Spreadsheet Interpreter to Native Excel, and the simulation will run. Now after saving the model and reopening, all the embedded Charts and Tables have VALUE errors. Not sure if the two are related. Going to check #4 Mysterious VALUE next. Also, while not (yet) running Office 365, I'm running into a similar issue to #30 where I have to reload Argo every time I open Excel. Ironically, the VALUE errors only seem to appear after I load Argo.
at Microsoft.Office.Interop.Excel._Application.get_Range(Object Cell1, Object Cell2) at ArgoXllDev.ExcelAddressUtil.ParsePositionInfo(String arg, IntPtr defaultsheetid, Int32& r1, Int32& r2, Int32& c1, Int32& c2, String& workbook, String& worksheet) at ArgoXllDev.PrecedentMiner.BuildPrecedentChain() at ArgoXllDev.RegisterUDFLib.__Argo_BuildPrecedents__()