Forum Discussion
Problem ExcelScript in excel files with compatibility mode 97-2003
I don't really know if this is the problem, but after many times of trying to run the most simple lines of code in Excel Typescript,
LearnExcelScript I hoped to find an answer here:
https://learn.microsoft.com/en-us/office/dev/scripts/testing/platform-limits
but it does not mention the Excel file type.
6 Replies
MichelleRanMSFTMicrosoft
Hi LearnExcelScript, thanks for your question! Office Scripts should be supported in .xls files as long as you open them in a recent Excel client. It's possible there are other issues with your workbook that prevent the script from working properly. Could you share a session id and/or a sample workbook (sensitive data removed as needed)?
MichelleRanMSFT Thank you for jumping in!
- MichelleRanMSFTAh, I see - there does indeed appear to be a bug with the getUsedRange API when run on workbooks in compatibility mode. We've logged a bug with the relevant team, although we don't have a timeline to share at the moment. Thanks for reporting this!
LearnExcelScript I hoped to find an answer here:
https://learn.microsoft.com/en-us/office/dev/scripts/testing/platform-limits
but it does not mention the Excel file type.
