I downloaded a workbook for depreciation and want to simplify some of the formulas. Some of the formulas refer to several named ranges and I would like them to just refer to a cell or several cells. When I try to delete the named range I find that the name is grayed out. The workbook is not protected. How do I work around this or change a setting so I can discard the range names. When I do try to write a simple formula it automatically picks up the range names.
For example: When I try to write =M16+O16 Excel changes it to