Excel 2007
Ribbon Tab: Formulas
Ribbon Tab section: Defined names
PROBLEM: Cannot define new names or edit existing ones since the options "Define Name" and "Create from Selection" are disabled. Even if I click on "Name manager", the "New", "Edit", and "Delete" buttons are disabled.
Additional info:
a) This problem is specific to this workbook only; if I open a new workbook everything is fine (unfortunately I cannot do that because I have 2 weeks of work already invested in this workbook)
b) Until now, I have been using this same file for 2 weeks, being able to define names without any problem
Please help
Thank you.
Ribbon Tab: Formulas
Ribbon Tab section: Defined names
PROBLEM: Cannot define new names or edit existing ones since the options "Define Name" and "Create from Selection" are disabled. Even if I click on "Name manager", the "New", "Edit", and "Delete" buttons are disabled.
Additional info:
a) This problem is specific to this workbook only; if I open a new workbook everything is fine (unfortunately I cannot do that because I have 2 weeks of work already invested in this workbook)
b) Until now, I have been using this same file for 2 weeks, being able to define names without any problem
Please help
Thank you.