How to use Excel FILES a secret, powerful hidden function 12:55 pm June 5, 2024 By Julian Horsey ...

You can edit and save Excel 2003 files in Excel 2007. While you are using a file in compatibility mode, grayed-out menu choices indicate that the feature is unavailable in Excel 2003.

DATEDIF (), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use it.

You can show File Path on Title Bar in Excel and Word by creating and running a Macro - and even in Quick Access Toolbar too. This post explains the process in detail.