November 13, 2020
Simple question, yet is there a best practice approach?
I've 2 workbooks. One performs a VLOOKUP against data on the second workbook. If I email the 1st workbook outside of my company, the client sees the formula in the cells.
Is there a way to email the workbook to the client as values only?
There were not too many worksheets so I selected the data and did a 'drag' show values as option.
I just wondered if there was another to do it? Ideally not macro based as I can't add macros to multiple machines. I can't ask the client to do things there end.
July 16, 2010
There's no setting as such that you can turn on that converts your formulas to values. The only way to do it is to copy and paste them as values, which can be automated with VBA that's stored in the file itself, i.e. not dependent on the computer the file was created on. Of course you'd want to do this in a copy of the file otherwise you'd lose the formulas.