Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
Alteryx Designer Desktop Knowledge Base
Definitive answers from Designer Desktop experts.Alteryx creates 2 .BAK files when trying to append data to an existing Excel file.
Environment/Details
When running a workflow to append data to an existing Excel file, Alteryx creates 2 .bak files and the original .xlsx file disappeared. When running the workflow the second time, one of the xlsx.bak files turns into an .xlsx. When running the workflow a 3rd time, it turned into 2 xlsx.bak files again. It may happen whenever updating a pre-existing file.
Cause
The issue is user-specific. When you press F5 to refresh the Folder, one of the .xlsx.bak is replaced with an Excel file .xlsx. The issue is not related to Alteryx, but to Windows. The problem is that the Folder is not refreshing automatically in Windows.
Resolution
Explorer not Refreshing
When running a workflow to append data to an existing Excel file, Alteryx creates 2 .bak files and the original .xlsx file disappeared. When running the workflow the second time, one of the xlsx.bak files turns into an .xlsx. When running the workflow a 3rd time, it turned into 2 xlsx.bak files again. It may happen whenever updating a pre-existing file.
- Alteryx Designer
- All versions
- Excel
Cause
The issue is user-specific. When you press F5 to refresh the Folder, one of the .xlsx.bak is replaced with an Excel file .xlsx. The issue is not related to Alteryx, but to Windows. The problem is that the Folder is not refreshing automatically in Windows.
Resolution
Please contact your IT team to assist you to resolve the issue. These web resources should get you started.
Folders Not Refreshing Automatically In Windows 10
Desktop or Folders Not RefreshingFolders Not Refreshing Automatically In Windows 10
Explorer not Refreshing
