2 Replies Latest reply: May 15, 2014 10:15 AM by Gary Morris RSS

    Export from V11 Project files not refreshing MS Excel 2010 worksheet inc. formulas

    benmccarthy _

      Hi All,

       

      When exporting via a project file from Monarch V11 to MS Excel 2010 we are finding the worksheet not updating if there is a formula relating to the data on the same worksheet.  For example if we are refreshing the data in columns A-E or the worksheet and there is a formula in column F relating to this data, the dataset in columns A-E does not refresh when the export has been run via the project file and we simply get an "Export Cancelled" message in the Progress window in Monarch.

       

      Has anyone experienced this and is there a resolution?