This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have two processes that export data into XLSM files. When other users try to open these files after the workflow completed, the attached Excel error message appears. The users cannot access the file, no matter what buttons they push in Excel. I am the only person who can open these files. They are not protected or secured in any fashion. Something happens when Alteryx runs. Is there a locking mechanism? Has anybody encountered this problem? Please help.
I recall seeing this message in the past when trying to have Alteryx write an Excel worksheet where the worksheet name has too many characters. I think Excel only likes up to ~30 characters for worksheet names.
Have you tried exporting to any other excel file format, like XLSX or legacy XLS? Do you encounter the same issue?
Out of curiousity, is there a reason you export in the macro enabled workbook? If you are exporting the data and subsequently running a macro, would you be able to also build that macro out in Alteryx to output to a different file format that does not have this error?
On a different thought process, where is the file being saved? If it is on a server or a shared drive, the default settings may need to be changed. Please see below.
You may need to also have the other people attempting to open the file change the "Trusted Location" settings.