Update changes to drag and drop images to excel

Question

Update changes to drag and drop images to excel

Pham Hoang Hung 21

Hello everyone.
Currently I have 2 computers using 2 different versions of excel.
Build 1910 and Build 2003
In build 1910, it is not possible to drag and drop images from the website into excel. Build 2003 allows you to drag and drop images from the website into excel.
Can someone tell me where this update is available. I want to get official information about this change.

Accepted answer

0 additional answers

Your answer

Answer 1

Emily Hua-MSFT 27,796

@Pham Hoang Hung
What versions of Office are you using now?
Please go to 2 computers in turn, click File > Account > Product Information, check the product name, such as Microsoft 365 Apps for enterprise, Office 2019 Home & Business or others.
If they are Microsoft 365 Apps for enterprise, please also check the update channel, such as Current Channel.

You may take a screenshot and share it with us. Then I would update the corresponding solution or suggestion.

Looking forward to your reply.

------------------------------
Update------------------------------------

Thanks for your sharing.

According to your image, I translate the content of update channel is the Monthly Channel (It is called Current Channel Now).
The version is Version 1810 (Build 11001.20108) which is released on November 3, 2018. But I could not reproduce this issue on this version. I suggest you update Office for a test.

It needs to check the product information on another device.
1 If it is also Office 365 ProPlus (Now it is called Microsoft 365 Apps for enterprise) and its update channel is Monthly Channel, then you could update Office to Version 2003 on this computer via running the following command with the same bulid number.

Please close all Office applications, press Win and R at the same time to open Run dialog, then enter the command "C:\Program Files\Common Files\microsoft shared\ClickToRun\OfficeC2RClient.exe" /update user updatetoversion=16.0.*<Build Number>*, then press OK.
Such as the newest one Version 2011 (Build 13426.20404), updatetoversion=16.0.13426.20404.

2 If it is Office 365 ProPlus with different update channel, then you may find the same version 2003 with different bulid numbers on the article "Update history for Microsoft 365 Apps (listed by date)". You could choose one to update on this computer.

Any questions, please let me know.

If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Pham Hoang Hung 21 Reputation points

2020-12-28T06:41:10.983+00:00

Thanks for your respond.
I'm sorry but I only have one device here.

Very sorry it is japanese.
On the other one, it was Build 2003 in 1810.
Emily Hua-MSFT 27,796 Reputation points

2020-12-28T07:44:25.147+00:00

@Pham Hoang Hung
I updated my previous answer, please hava a check.
Besides, as the forum is a public place, to protect your privacy information, I covered your account information.
Thanks for your understanding.
Pham Hoang Hung 21 Reputation points

2020-12-28T08:26:29.29+00:00

Thank you so much for your answer, it helped me a lot.
Can I ask you a little more? Currently the user side cannot update to the new version for some reason due to a problem specified in the company, they ask me to make sure that if they update to the new version there will be drag and drop features update. So is there any information that in build 2003 can use that feature please show me. Thank you !
Emily Hua-MSFT 27,796 Reputation points

2020-12-29T08:16:30.467+00:00

@Pham Hoang Hung
In fact, whether it is Version 1801 or Version 2003, I found that I can drag and drop pictures directly from the web page to the Excel worksheet on my test environment (I use Edge).
If users have policy restrictions on updating Office, please check the browser and change the broswer to have a test.

Please also ask the user, is there any error message when when dragging the picture to the worksheet fails?
If yes, please let me know.
Pham Hoang Hung 21 Reputation points

2020-12-29T08:38:07.8+00:00

Thanks for answering.
I was missing the information, sorry.
I wanted to drag and drop images with base64 format into excel but not.
for example in the link below.
https://jsfiddle.net/casiano/Xadvz/

Version 1801 is can not, but Version 2003 it's ok.
Emily Hua-MSFT 27,796 Reputation points

2020-12-29T09:52:52.603+00:00

@Pham Hoang Hung
Thanks for your reply.
I could reproduce this issue on Excel with Version 1810 (Build 11001.20108), the following gif shows the details.

But this issue goes away on Excel with Version 2003 (Build 12624.20442), which version I randomly selected from the update history article above.
So I think this issue could be resolved by updating Office.
Pham Hoang Hung 21 Reputation points

2020-12-29T11:16:06.863+00:00

I got it, thank you very much.
Pham Hoang Hung 21 Reputation points

2021-01-06T06:55:51.117+00:00

I tried to update so the latest version, currently build 1910, is informed that this is the latest version. How do i update ?
I'm sorry that the image is in japanese but it means this is the latest version.
Emily Hua-MSFT 27,796 Reputation points

2021-01-07T07:15:53.627+00:00

@Pham Hoang Hung
Does the user's organization use Group Policy to set the update source for Microsoft apps?

If not, please go to the Reigistry Editor, locate to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\ClickToRun\Configuration, check wehther the value of CDNBaseUrl is http://officecdn.microsoft.com, such as http://officecdn.microsoft.com/pr/492350f6-3a01-4f97-b9c0-c7c6ddf67d60 or the shared folder of organization.

Share via

Update changes to drag and drop images to excel

0 additional answers

Your answer