Hi Everyone,
I’m encountering an issue when trying to retrieve worksheet information from a .XLSM file using Excel Modules. Specifically, I receive error [501] when using both the “List Worksheets” and “List Tables” modules.
Here are the error messages I receive:
These modules work perfectly fine with .XLSX files.
Is this a known limitation or possibly a bug? Any insights or solutions would be greatly appreciated!
It’s likely that the .XLSM files are not supported.
I’m sure others would agree that this is a nice feature to have.
You can submit this suggestion to the Idea exchange, under App improvement ideas.
Don’t forget to search for it first, just in case someone already suggested it, so that you don’t end up creating a duplicate.
A workaround would be to convert the files into XLSX or Google Sheets files.
samliew – request private consultation
Join the Make Fans Discord server to chat with other makers!
I changed the Worksheet name to a simple single word name and tried to put it’s name manually on the “Worksheet” field, same error.
I found this very troublesome information on Microsoft API docs regarding XLSM files on Power Automate. Is this the same for Make?
Source here
The XLSM file owner made some changes on it (regarding de Warning message above) and then I was able to get the Worksheet name normally. So the conclusion is: **Some content of the XLSM file maybe incompatible with the Microsoft Online Conector, so be like Batman and prepare yourself testing the XLSM features with Make Excel Modules first! 
