Disable a file from searching for a link update on a different user'scomputer

M

Michael Lanier

When I send a file containing macros to another computer it prompts
the user to search for link updates if they have Excel on their
computer. I would like to disable this prompt since nothing my file
contains needs to be updated. (However, it is possible one of my
file's worksheets will require the updating feature in the future, but
not now.) Is there a macro that will accomplish this? Thanks.

Michael
 
D

Dave Peterson

I would convert the formulas to values and share that version of the workbook.

You could convert all the formulas or if it's important, just the cells that
contain UDFs that are in your other workbook/addin.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top