Are you trying to save the file as a different type than .xls (such as
..csv)? If so, then Excel is warning you that the new file type cannot
support formulae and so it will put the value of each formula in the
cell. Just make sure when you go to File | Save As that you select
Excel Workbook as the file type in the pull-down of the bottom panel.

Hope this helps.

Pete