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.