Forum Discussion

paul_gunda's avatar
paul_gunda
Copper Contributor
May 11, 2020

Excel Data Refresh error

Hello everyone,

I am trying to refresh an Excel Pivot table Report using the Data Refresh option. The excel has 5 tabs with pivot tables in each . The excel connects to a Cube/Database in the backend and tries to refresh data.  I keep getting this pop-up below, and no one seems to know what this error is.

Tried several different options but no success yet. Can you let me know if anyone has seen this error in Excel before while doing Data Refresh. Thanks in advance

 

 

excel

1 Reply

  • AshaKantaSharma's avatar
    AshaKantaSharma
    Iron Contributor
    May 12, 2020

    paul_gunda I think one or more headers data has been deleted somehow after creation of PT from the core dataset which might be causing the issues. As one can not create PT with a NIL header we are getting the error messages.

Resources