I have a user who is trying to insert an object into Excel, but it's not retaining the file name once inserted. I clicked on the Link To File option and it kept the name, but in order for it to work I have to click it each time. Is there a way to set it to always use the Link To File option as default? The user was recently upgraded from 2003 to Office 2010 and had the ability to insert objects without taking this extra step. Thanks!

Hi,

Do you mean you hope the Link to file option is always selected when you are inserting object automatically, and you can get information of object as shown in the following figure?

If my understanding is correct, I regret to tell you that you have to check the Link to file option each time manually, and there is no way to set it as default.

If my understanding is incorrect, please share the screenshot to us so that we can get more accurate solutions to this problem.

Regards,

George Zhao
TechNet Community Support