Any protocol or advice on how to remove dynamic named ranges?

[ExcelOnTheClock]

Hi folks,

I've inherited an Excel file with 32 dynamic named ranges. It's god awful trying to track down the mechanics of this stupid Excel file. The dynamic named ranges are a main reason for that. Is there a good way to fix something like this? I understand the mechanics of dynamic named ranges, but I'm not sure of the best to make this file more intuitive.

I guess a broader question is: do you have any suggestions / ideas on how to structure a reverse engineering of a messy spreadsheet?

Thanks in advance!

 

[Micron]

Ribbon>Formulas>Name Manager
Delete or edit the ranges?

 

[ExcelOnTheClock]

I assumed that, but it's hard to do that quickly on dynamic named ranges--I have to figure out what all it's calculating.

 

[Micron]

The only time I used dynamic ranges was to push data from Access to a wb that contained charts. Since the chart data could be more or less from time to time, I used dynamic range for the chart. So I'm not grasping what the issue is (beyond perhaps having so many dr's) since the ranges don't actually calculate anything - they provide a dynamic range of data for those calculations, charts or whatever it is that is based on them?