I have a file that points to a separate database. I need to convert all formulas that start with a specific text to values when a user saves the file. Currently the file is a Excel Macro Enabled Template and opens in read only. I would like the file to convert all formulas on all sheets that start with "=E10" to values when it saves so the file doesnt come back with a #NAME error. I don't want to change any of the sum or vlookup formulas and the formulas that start with "=E10" can continue with a multitude of different variances. Is this possible?