Forum Discussion
Notes in Excel
What do you mean under disabled notes, you don't see New Note on ribbon, or it's greyed out, or you can't see existing notes?
Just in case, on modern Excel notes are under Review -> Notes -> drop-down with options. Under Insert tab are only Comments.
On the 'Review' tab, everything for 'Notes' except for 'Show all notes' is greyed out and 'Links' are greyed out. Everything on the 'Insert' menu is greyed out except for 'Header and footer' and 'Signature Line' in the 'Text' section. The same applies for these to the 'right-click' context menu. They are there but greyed out. Also, on the title bar, the file name is shown in addition to a suffix 'Group'. Whatever that is I suspect is why. And, it only applies to this workbook. Other workbooks are OK.
I figured it out. There were two tabs selected in the workbook the last time I saved. With only one tab selected, everything is OK.
David Lambert , great to know, thank you for sharing