Excel Crashes w/ ODBC Query After Copilot Integration
Ever since this was forcefully installed the other week, all our files with ODBC connections to our ERP database are crashing when refreshing. My entire company has been using these queries for years, this all started when this update rolled out. I've been writing SQL for 20 years, I know our database, I created these files, there's nothing wrong with the queries and nothings been depreciated/legacy from the recent update from our understanding.
We confirmed the recent forceful Copilot integration is likely causing the issue, Version 2604 (Build 19929.20136). A machine which did not have the update has no issues with the files or query refresh. We then installed the update, replicated the problem. There's been no change to our server environment either.
Our IT Department can't remove Copilot from Excel, there's no option locally on the users machine or a specific license to manage for tenants on the Office 365 Admin portal. Anyone with a working solution for Office 365 Business would be greatly appreciated.
DOA Solutions Thusfar:
Uncheck "Turn on optional connected experiences" from File > Account > Account Privacy > Manage SettingsFile > Options > Copilot (does not exist)Office 365 Admin Portal remove license (does not exist)
[link] [comments]
Want to read more?
Check out the full article on the original site