Problem with linked pictures

Question

Hello. 

I would like to report an issue in Excel 2016, and I would also like to know if you guys have the same problem. I think it might be a bug.

When I paste a linked picture of a range of cells from other sheet, Excel breaks in some awkward ways. For example, comments won´t work properly (they don't appear when I hover the mouse). Drop down list symbol (from data validation) is also gone.

Well, when the linked picture is from a range of cells from the same sheet, then I will have no problem. But when it's from a range of cells in another sheet, then puff! Excel breaks. It's not serious but I thought that my workbook had a really bad problem that I couldn't solve.

How can I report this? Do you have/fell the same problem?

Regards,

Nuno Teixeira

Answer 1

Thank you for the prompt reply.

Well, the safe mode won't work. I tried but still got the same problem.

I got the same problem in my personal computer and in the computer that I have got at the office. Both of these are Windows 10 Anniversary. 

Here is a link to a Workbook where I am facing the problem:

https://1drv.ms/x/s!AjKS3Nj0Qhe1tloouGvw\_7uk4hfZ

Thank you.

Answer 2

Hi Nuno,

Let’s open Excel in application Safe Mode and check how it works.

To do that, press the ‘Windows + R’ key on the keyboard.  

In the Run open box type in ‘Excel /safe’ and hit ok.  

Note: There is a space between excel and /.

If application Safe Mode works, try disabling the add-ins associated with Office applications and check.

To do that, do the following.

1. Open Excel Click on File and then click on options.
2. In the Options Window click on Add-ins.
3. Select Com Add-ins in the Manage list in the Add-ins section and click Go. Now uncheck the all the add-ins and click Ok.

If the issue still persist you may Repair Office 2016 Installation and check if it helps.

You may refer to below link to Repair Office 2016 installation.

http://office.microsoft.com/en-in/project-help/repair-or-remove-office-HA010357402.aspx

Hope it helps. Try the suggestions and let us know the result at your earliest convenience.

Thank you.