Saving as .xlt

  • Thread starter Thread starter bird007
  • Start date Start date
B

bird007

Hi,

I have made a form with several formulas, have locked those cells with the
formulas and have protected my sheet.
When I save as .xlt one particular cell loses its formula, can anyone help
on this problem?

Thanks,
K
 
If you close excel and reopen it in safe mode:

Windows start button|Run
type:
excel
and hit enter

And make the change, save the file, close the file and reopen it, does the
formula disappear?

If no, then maybe you have a macro that's "helping" and converting the formula
to values.

(By starting excel in safe mode, excel won't allow any macros to run.)
 
Back
Top