Alteryx Sharepoint Connector reading xlsm workbooks

[Brian32]

Does anyone have a workaround for getting the Alteryx Sharepoint Connector to be able to read a xlsm file?

[JerryCooperCMA]

In my experience and from what I've read recently, there is no good workaround for this, not even using Power Automate as a file handler. Best bet for now is to have owner of the Excel macro-enabled file(s) do a "Save As" in openXML (.xlsx) format.

[Vinod28]

Hi @Brian32 ,

Thank you for reaching out regarding the issue with reading .xlsm files using the Alteryx SharePoint connector. This is a known limitation, as the connector currently doesn't support macro-enabled Excel files directly. However, there are a few workarounds that other users have found helpful:

1. Convert .xlsm to .xlsx:
   Since the SharePoint connector supports .xlsx files, converting your .xlsm files to .xlsx Format can be an effective solution. This can be done manually or automated using tools like Power Automate.

2. Sync SharePoint with OneDrive:
   By syncing your SharePoint library with OneDrive, the .xlsm Files become accessible through your local file system. You can then use Alteryx's standard Input Data tool to read the files.

3. Use Alteryx's Python Tool:
   For more technical users, the Python tool in Alteryx can be utilised to download and read .xlsm Files from SharePoint using appropriate libraries.

For more detailed discussions and user experiences, you might find the following resources helpful:

Reading SharePoint Excel (.xlsm) files on Alteryx - Alteryx Community

View SharePoint files in File Explorer - Microsoft Support

[abacon]

@Brian32 Your best best will be to connect to the file using the regular file input.

If you are on Gallery, you can give it access to your SharePoint so it can read in the regular Input Data tool. The SharePoint Connector tool is limited with it's uses for sure.

Bacon