Home Forums Mac Software Mac Applications Excel safeguard against overwriting formulas?

I have just checked, and the process is exactly the same in Excel 2004.

Also checked the Help issue - in 2004, the help windows have a working red close button in the usual location at the top left of the window. I'm using Snow Leopard 2.6.1

My usual way of solving issues of odd behaviour of this sort is to:

• Quit all Microsoft programs
• Move the relevant preference file to the desktop
• Re-launch the troublesome program (Excel, in this case). A new default preference file will be created.
• If this fixes the problem, then trash the delinquent preference file from the desktop.
• If not then return it to its original location so any other preferences may be retained.

The location of the preference file for Excel 2004 is:
~/Library/Preferences/Microsoft/com.microsoft.Excel.prefs.plist

For Excel 2008 it is:
~/Library/Preferences/com.microsoft.Excel.plist

~ represents the users home directory