Any way to restore cross-sheet references?
I suspect the answer will be what it always is: "no you can't do that but you can submit an enhancement request" but I'm going to ask in the desperate hope I might be wrong...
How can I see what named ranges apply to a sheet? I am attempting to reference another sheet in a countif formula, and when I go to rename the referenced range (don't even get me started on how angry the automatic naming of ranges / inability to see what they refer to makes me), but I keep getting an error that the name I want use has already being used on a range in that sheet.
How can I find out what this other range is?
Is there a name manager?
Can I remove a named range?
How can I select a previously named range to use again?
Thanks in advance and in frustration.
Help Article Resources
Check out the Formula Handbook template!