Programming Questions? Ask a Programmer for Answers ASAP
The way to save formulas only, is to delete the cells that have fixed values keeping only the cells that have formulas, then choose the Formula display option, i.e.
Excel 2003, 2000, XP, 97
click Tools > Options > View tab > Formulas.
click Office button > Excel Options > Advanced > Display options for this worksheet...> Show formulas in cells instead of their calculated results
If you have a large sheet with values and formulas I can do it for your using vba code if you like. Let me know if that is what you want so that I can send you the instructions for posting the file.
Hope this helps.