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?

Improve this question
1
  • 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, 2016 at 19:39

1 Answer 1

Reset to default
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).

Improve this answer

Not the answer you're looking for? Browse other questions tagged .