Issue Writing Excel Output to SharePoint

[Gabacho]

We have some pivot tables, charts and a.dashboard as part of an Excel file in SharePoint that also has some web parts. All of the visuals in this file are fed by an underlying sheet that we are updating with Alteryx. We are updating specific ranges rather than overwriting the entire sheet.

The issue is when Alteryx is used to do this update the various links to that data tab revert to reading from the .bak file rather than the updated. xlsx file. We have tried the approach of deleting the ,bak file, which breaks the file completely. 

We are looking for options to get around this issue.

[TrevorS]

Hello @Gabacho 

Can you please upload a copy of your workflow and some sample data that can be used for the Community to troubleshoot this for you?

Thanks!
TrevorS

[Gabacho]

I could post the workflow, but the issue happens when opening the updated excel file in Sharepoint.  If I manually update the file, the issue doesn't occur so the workflow is only half of what's needed to test the senario.