+ Reply to Thread
Results 1 to 2 of 2

HELP REQUIRED: Pivot Chart from Power Query on New Excel Sheet throws exception 0x800A03EC

  1. #1
    Registered User
    Join Date
    11-17-2017
    Location
    UK
    MS-Off Ver
    64-bit 2016
    Posts
    1

    Question HELP REQUIRED: Pivot Chart from Power Query on New Excel Sheet throws exception 0x800A03EC

    I posted this issue on the PowerBI forum but someone there suggested I try posting it here as they were unable to reproduce my issue.

    I have an Excel 2016 workbook (I'm using 64-bit Windows 10 and 64-bit Excel 2016) with a number of Power Queries off of a data table range. The output of several of those Power Queries are then used in Pivot Charts (each of which is located on its own sheet). This has been working fine for a month, but now I get an exception whenever I select one of the chart sheets.

    I've created a minimum working example workbook from scratch (no relation to the workbook I've been using above, and with manually entered data) and I experience the same exception.

    To create the minimum working example I typed the following data into the first sheet (called raw-data):

    col1 col2 col3
    row1 5 5 5
    row2 5 2 5
    row3 3 3 4
    row4 4 5 5
    row5 4 4 3
    row6 5 5 2
    row7 5 3 5
    row8 2 4 5

    I labelled the range
    Please Login or Register  to view this content.
    with the name "data", and then I selected Data ... Get & Transform Data ... From Table/Range and create a Power Query called "data-query-out" as follows:

    Please Login or Register  to view this content.
    I named the worksheet that this Power Query's output is placed on "transformed-data". I then selected Insert ... Pivot Chart and used "data-query-out" as the Table/Range input and chose for the Pivot Chart to be placed on a new worksheet. I named the Pivot Table sheet that is produced "pivot-data" and selected the checkboxes alongside each of the Pivot Chart Fields.
    I then right clicked on the Pivot Chart and selected Move Chart, and selected New Chart, giving it the name "pivot-chart". I immediately get the following exception:

    NOTE: in the following CODE segment I have had to replace < with |||--- and > with ---||| in order to avoid this forums overstrict html blocking.

    Please Login or Register  to view this content.

    I can still update the graphs once I've closed the exception dialogue, but whenever the charts are on their own sheet it will appear again when I reselect the tab, or when I open the graph element properties panel.

    Anyone got any idea what is causing this issue, and how to fix it - I'd really appreciate your help?

    Thanks,

    PowerBIGuest

  2. #2
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Cool Re: HELP REQUIRED: Pivot Chart from Power Query on New Excel Sheet throws exception 0x800A

    I tried to reproduce your issue - no success, everything dancing & singing
    maybe check for duplicated any names of something.
    try with default names from excel
    or
    (because I got similar error last time) after create chart save and close workbook then open and try to move as new chart.

    edit:
    why you creating unnecessary step with loading query to the sheet or from connection?
    load as connection, check add to DataModel and create pivot Table/Chart from DataModel
    Last edited by sandy666; 11-17-2017 at 08:21 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. SaveAs method throws exception
    By gbritton_td in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-06-2015, 09:29 AM
  2. Excel Automation: Setting WindowState throws exception in Excel2013
    By Anandh123 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-03-2013, 02:02 AM
  3. Copy a worksheet throws "Exception from HRESULT: 0x800A03EC."
    By i3tech in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-15-2006, 08:40 AM
  4. [SOLVED] Exception from HRESULT: 0x800A03EC
    By nano2k in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 07-21-2006, 07:20 AM
  5. get_Range function throws an exception
    By Mikil in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-25-2006, 10:15 AM
  6. Replies: 0
    Last Post: 04-11-2006, 11:45 AM
  7. Excel throws exception if cell being edited
    By Pixeled in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-06-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1