This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 44%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Hi,
I am trying to merge several .xlsx files using copilot. Everything works fine until copilot tries to transfer the merged data into the requested workbook. It says: "...transferring the merged data back into your open workbook is blocked."
Both the target workbook and the merged files are on onedrive.
Is there anything I can do to enable the transfer?
Thanks!
Building and customizing solutions using Microsoft 365 Copilot APIs and tools
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 62%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Yes, you should be able to transfer merged data to an Excel workbook on OneDrive. If Copilot can read but not edit it, try enabling Edit mode, setting Calculation Options to Automatic, enabling connected experiences, and confirming Excel and OneDrive use the same Microsoft 365 account.