I have now read about 40 tips on this subject and it does not appear anybody has a solution other than "click inside the cell and hit enter".

I have to create many spreadsheets with thousands of rows of excel formulas that excel is not recognizing until I click inside the cell and hit enter.

Here are the relevant details:

- I am exporting from Toad to create Excel spreadsheet
- I have Toad settings to
**Only Use General Formatting**and the column in question is general formatted - Example formula:
`=HYPERLINK("THE_RELATIVE_PATH","FILE_NAME.pdf")`

- In excel
**Calculation Options**are set to**Automatic**(and were at the time of creation)

Formulas just appear as text, even though they are general formatted and formulas. Clicking in Cell and hitting enter will calculate them.

The following things do not work:

- Highlight either Cell or Column and click
**Calculate Now**under**Formulas -> Calculation** - Changing Excel Options for
**Formulas**to**Manual**and checking**Recalculate Workbook Before Saving**, then saving the file. - Any of the options from
**MSDN**Here

I'm at a loss for how to accomplish this seemingly simple task. I've even found tips from microsoft that essentially say "If you import and it doesn't calculate, manually calculate by clicking the cell and hitting enter." That is not a solution unless you're importing a dozen rows.

textformatting, which is default when using import from Excel. Ifgeneralis not the appropriate formatting to calculate a hyperlink, what is? And why does general formatting work to calculate a hyperlink? – red6 Oct 24 '15 at 18:41