Friday 25 September 2009

Vanishing formula bar in Mac Office Excel 2008

A couple of weeks ago my formula bar in Excel 2008 on my Mac just vanished into thin air - gone. I tried various remedies to get it to reappear, but none worked, including the obvious, turning on "formula bar" in the view menu. Eventually I managed to track down a Macrumors forum thread where someone had fixed the problem. Here's what you do:

- Close Excel and any other running Office apps
- In Finder, go to your home directory and then to /Library/Preferences/Microsoft/Office 2008/
- Delete the file called "Excel Toolbars"
- Restart Excel

This should restore the formula bar for you.