Forum Discussion
alee023
Apr 03, 2024Copper Contributor
How can I automatically delete data connections in Excel ONLINE (Sharepoint)?
I have created an Excel workbook in Sharepoint with PivotTables with a PowerBI connection (a Lakehouse in Fabric). Since the data itself gets updated monthly, I'd like a copy of the Excel without the...
SergeiBaklan
Apr 03, 2024Diamond Contributor
To my knowledge we can't remove connection with Office Script. All workbook methods are here ExcelScript.Workbook interface - Office Scripts | Microsoft Learn