0

Run a Macro on an Excel 2007 workbook, now formulas no longer work in the modified workbook? I can type a simple (like "=5") in a blank cell and hit enter and what I typed is shown, not the result of the formula. Same for complex formulas ("=vlookup(..."). How do I fix?

closed as unclear what you're asking by Máté Juhász, fixer1234, DavidPostill, mdpc, Jakuje Aug 9 '16 at 18:58

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

  • I don't think it's related to the macros. What is the number format of the cells? Can you post some screenshots? – Máté Juhász Jul 13 '16 at 19:39
1

It's possible you accidentally turned on the "Show Formulas" option. You can disable it by going to the Formulas tab→Formula Auditing→Show Formulas. Alternately, the hotkey is Ctrl+~ (that's the tilde key at the top left of your keyboard).

Not the answer you're looking for? Browse other questions tagged or ask your own question.