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!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.

Quote

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.

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