HOW to retain spreadcsheet formulas when "Save As" eksewhere?

[roduke 41]

My problem is to retain all FORMULAS on a Spreadsheet file when Save As to any other location, particularly to CD discs. Save easily, but without a single formula, and there are in excess of a hundered of them.

At my inexperience level I avoid anything drastic such as reinstalling Office or whatever. The method I have used successfully is:

1. Highlight any cell with a formula.
2. Go to any empty cell and Edit/Copy.
3. Right click/select Paste Special.
4. Click Formulas.
5. Click Escape twice.
6. Click keyboard Delete to empty that cell.

But now all is lost by inability to use the Paste Special grayed out item.

I do hope one of you experts can help with this. And if, in addition, you have another means of retaining spreadsheet formulas when saving elsewhere so much the better.

Thanks!

[Sidewinder]

Formulas are saved with an Excel workbook as a matter of course. It is not necessary to do anything special. I'm unsure of your method though. Seems you're copying a formula to a new cell and then deleting it.

1. Highlight any cell with a formula.
2. Go to any empty cell and Edit/Copy.
3. Right click/select Paste Special.
4. Click Formulas.
5. Click Escape twice.
6. Click keyboard Delete to empty that cell.

If you're goal is to copy a formula to a new cell, this will work

1. Highlight any cell with a formula and Edit/Copy.
2. Go to any empty cell and Right click/select Paste Special.
3. Click Formulas.
4. Click OK

Excel will fixup the formula based on the new cell location. For example if you're summing cells, =sum(A1:A9), and you copy the formula to column D on the same row, Excel will change the formula to =sum(D1:D9)

When saving the workbook, ensure the Save as type is Microsoft Excel Workbook