Convert XLX to XLXS in Sharepoint Folder automatically

Mark Crocker 1 Reputation point
2021-06-30T00:39:26.253+00:00

Hi there,

I have been looking for Flow solutions that aren't paid but can't find one. I have found some tips on Powershell for converting XLS to XLSX but that is all for local directories. I wanted to have a process run automatically when a folder is populated with files on Sharepoint.

Is there a script anyone can share? I am no programmer but can understand the basics of powershell and basically am not sure how to use powershell with Sharepoint libraries and folders.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,628 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Emily Du-MSFT 41,786 Reputation points Microsoft Vendor
    2021-06-30T09:20:27.49+00:00

    @Mark Crocker

    Per my test, converting .xlx files to .xlxs files automatically in the SharePoint folder is not available.

    As a workaround, you should change files extension in the client application manually. File -> Save as -> Choose .xlx type -> Save.


    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.