Edit Range Define in Name Manager Has Error

I worked on an excel sheet (1st) which has a lot of "defined Range"

When I duplicate that excel sheet to make to 2nd sheet, I went to Formula -> then Name Manager -> Edit the name of these "defined Range" to differentiate them with which has been defined in the 1st excel sheet

I can see these "defined Range" in the Name Manager of that 2nd sheet but when I move to a different sheet and need to paste the "defined Range" of the 2nd sheet, I could not find them

Is this an error of Excel and is there any other way than I need to defined range all over again (which is super super time-consuming)

Thanks in advance, really appreciate if someone could help me out

|

Could you share a test file with some dummy data in it and show an expected result?

When I copy a sheet with defined range, I get two name with different scope

•Beware of Scammers posting fake Support Numbers here.

Was this reply helpful?

Sorry this didn't help.

Great! Thanks for your feedback.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this reply?

Thanks for your feedback.

 
 

Question Info


Last updated May 1, 2024 Views 13 Applies to: