Excel 365 Name Manager rule - allowed characters - to enhance reusability & documentation of named formulas

Hi Sunny Schindler,

Based on your description, we understand that you want to enhance reusability & documentation of named formulas. We know that you can make your formulas much easier to understand and maintain by using names, However, we test Name Manager feature in Excel.

We found that rule has the limitation when we type special symbols. However, you may add Comment to describe the name. This article for you to reference: Use the Name Manager in Excel - Excel (microsoft.com). I am afraid we cannot meet your request directly. We really believe your requirement can improve our products and bring a better user experience. So, I request you to add your feedback to related developing team by add your feedback via Excel application, adding the feedback in the Office platform is the best way to report the problem to related team. Reference article: How do I give feedback on Microsoft Office?

Your understanding and patience will be highly appreciated.

Best Regards,

Tin

Hi Sunny Schindler,

Based on your description, we understand that you want to enhance reusability & documentation of named formulas. We know that you can make your formulas much easier to understand and maintain by using names, However, we test Name Manager feature in Excel.

We found that rule has the limitation when we type special symbols. However, you may add Comment to describe the name. This article for you to reference: Use the Name Manager in Excel - Excel (microsoft.com). I am afraid we cannot meet your request directly. We really believe your requirement can improve our products and bring a better user experience. So, I request you to add your feedback to related developing team by add your feedback via Excel application, adding the feedback in the Office platform is the best way to report the problem to related team. Reference article: How do I give feedback on Microsoft Office?

 

Your understanding and patience will be highly appreciated.

 

Best Regards,

Tin

My understanding is Microsoft preference of Formulas over VBA. I understand there are concerns such as security for VBA but I REALLY wish UDF has better support.

Example:

VBA is much more appealing than UDF when there is much more work to document named formulas especially this work is regarded as cost-center not revenue generating.... If you need more details, pls let me know.

One example is:

Conditional formatting formula behave different when same formula is in cell? Problem: feature of (Trace-Dependents of Formula) not available for Named Formulas Conditional formatting formula behave different when same formula is - Microsoft Community

FYI, named formula should have better support. Another example as follows: With VBA, export (with or w/o automated), losing 8 hours of work never happened to me...

Why Excel not warn invalid formula names not until file is re-opened? (file has been saved every 15 minutes) Why Excel not warn invalid formula names not until file is - Microsoft Community

Hi Sunny Schindler,

Based on your description, we understand that you want to enhance reusability & documentation of named formulas. We know that you can make your formulas much easier to understand and maintain by using names, However, we test Name Manager feature in Excel.

We found that rule has the limitation when we type special symbols. However, you may add Comment to describe the name. This article for you to reference: Use the Name Manager in Excel - Excel (microsoft.com). I am afraid we cannot meet your request directly. We really believe your requirement can improve our products and bring a better user experience. So, I request you to add your feedback to related developing team by add your feedback via Excel application, adding the feedback in the Office platform is the best way to report the problem to related team. Reference article: How do I give feedback on Microsoft Office?

 

Your understanding and patience will be highly appreciated.

 

Best Regards,

Tin

My understanding is Microsoft preference of Formulas over VBA. I understand there are concerns such as security for VBA but I REALLY wish UDF has better support.

Example:

VBA is much more appealing than UDF when there is much more work to document named formulas especially this work is regarded as cost-center not revenue generating.... If you need more details, pls let me know.

One example is: Conditional formatting formula behave different when same formula is in cell?Problem: feature of (Trace-Dependents of Formula) not available for Named Formulas Conditional formatting formula behave different when same formula is - Microsoft Community

Hi Robbie,

May I know if the issue has been resolved by above suggestions? Please let us know if you need more help.

Best Regards,

Tin