1 Reply Latest reply: May 15, 2014 10:13 AM by Data Kruncher RSS

    Export Failed

    dmorgan145 _

      Using Windows XP Pro, Excel 2007, Monarch V.10 Pro.  I open a report, create a model and export the table to excel. All is well at this point.  I then move the named range of the exported table to another worksheet within the same workbook, next to another exported table.  When I try to run the export again (overwrite table), I get the "export failed" message.  Am I doing something wrong or is this impossible?

        • Export Failed
          Data Kruncher

          Welcome to the forum.

           

          Exports from Monarch to that Excel file will fail if the range name has been corrupted. Open the Excel file and examine the list of range names, and specifically the ranges to which those names apply. If you see #NA or some other error in the range that Monarch is using for exporting, then you need to delete that range name, or manually make it a valid, legal range before Monarch will export properly to that file.

           

          My recommendation is to keep all Monarch exports on their own worksheets, and then build formulas on other sheets to refer to those Monarch data tables as necessary for your other Excel analysis work. Leave the Monarch stuff alone and all will be well. Modifying it in any way, like deleting the first or last row or column, and the named range will "blow up" and Monarch won't be able to export to that file (with that range name).