How to prevent add ins being included in distribution worksheet?

[dochsm]

The personal workbooks that I use on my machine use several home grown
add ins, some of which link to other workbooks on my machine.

However, the business workbooks that I produce and distribute to my
clients don't need those addins or the links.

How can I prevent my personal addins from becoming part of my business
workbooks so that my clients don't get warnings about links not being
updated?

 

[Dave Peterson]

Convert the formula with links to values is one way.

If I have a UDF (say) that is useful to others, I won't put it in my
personal.xl* workbook. That's for stuff that only I use.

If I want to share that UDF with others, I'll make a new addin and put the UDF
there.

Then I'll distribute that addin to each of the co-workers who need it.

And I'll tell them to put it in the same location on their harddrive -- like:

C:\excelutils\myaddin.xla

This makes any workbook that uses that UDF find the addin in the same location.

========
But if your problem is with links to other workbooks, you could put those other
workbooks in a folder on a common network drive -- and use the UNC path in your
links.