Dynamic name range in Excel

[bcsyeung]

Hi there,

I need help on this. I found this named range formula created from my colleague's workbook but I do not understand it and also this cannot be edited. Looks like it is a dynamic name range. Could you please teach me how to do it and also how to edit it?
I would like to attach a screenshot of the issue. Can you tell me how to attach it?

thank you
Bonnie

 

[Norie]

Can you post the formula for the named range?

 

[bcsyeung]

=Data!$A$3:$BO$2191. When I click edit name range it is greyed out

 

[Norie]

Is that it?

If it is in not sure it's a dynamic named range.

Are there any filters set up in the workbook?

Any data being imported from an external source?

 

[bcsyeung]

Is there anyway that I can attach the report for you to look at?