"Read only" files output issue

Hi,

Myself and some of my team members have similar issue with the opening Excel 365 ProPlus after we ran the module. The files show as "Read Only". Also if I decide to run the module one more time, it cannot access Output file, knowing that noone else have this open. We didn't have this problem with an old Excel, but it only started when we updated to the new 365 ProPlus version. Please help to resolve. I am able to access the file next day after I ran it but not right away.

Thank you,

Yuliya

Output

Accepted answers

All comments

danilang

Hi @yuliya_naumenko

Can you post an image of the configuration of your Output tool? I ask because Alteryx can't save directly to the cloud where your O365 Excel file will end up. There must be some back-end process(One-Drive?) that synchronizes the local and cloud copy.

Dan

yuliya_naumenko

Andrew_Sutherland

I have a similar issue. I find that local runs of Alteryx may produce corrupted .xlsx outputs if Excel 365 is currently running on my machine.

Details: Running Alteryx Designer version 2020.2.3.27789

Since I switched to Office 365, some of my Alteryx .xlsx outputs fail to save properly. The output file is locked as read-only due to currently being is use by another user and Excel reports that the file is corrupt when I try to open it (although it fixes without issue). This first happened after I switched to Office 365.

The output file sometimes unlocks if I close all Alteryx and Excel windows, but it remains corrupted. I suspect the issue occurs Alteryx tries to save a file at the same time that perform an action in Excel 365. My recommendation is to avoid using Excel 365 while an Alteryx report is running.

stein

I am having the same problem where the output becomes a read only file. I thought this was a SharePoint issue. But it is now happening when the output file is saved on the server. Is there any solution?

Robin_McIntosh

Edit - Found an error in part of my workflow that was causing the process to remain open. VBScript was trying to rename a sheet name that did not exist.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703