Skip to Content

Default "empty comment" value for all users (AKA leave empty comments...empty)

From the user guide page 184:

The small red triangle does not appear in one of the following cases: the comment is empty; the comment consists in three dots (...); the comment consists in the characters entered in the Empty Comment area in

...and page 432:

optionName parameter newValue parameter Option Name and Path on the Interface DefaultForEmptyComment character string User Options > Others > Empty Comment

Is there a way to set this default "Empty Comment" for all users, from the back end?

The system is saving every comment as '...' by default, which is a lot of unnecessary data for us. I'd like to change this to '', or Don't save empty comments somehow.

Also on page 427

Option sheetOption Option sheetOptionValue Show as Excel Comment 11 TRUE or FALSE

What does this do exactly?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 28, 2016 at 04:23 PM

    Thanks to my colleague Ian for finding this:

    To disable the “…” automatically you need to add the following to a MODULE (not the workbook) vba for any workbook you choose


    Dim EPMObj As New FPMXLClient.EPMAddInAutomation

    EPMObj.SetUserOption "DefaultForEmptyComment", ""

    End Function

    You must also reference the FPMXLClient from Tools>References

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2016 at 11:51 PM

    Version 10.1?

    From Users option go to Others-->Empty comment--> remove "..." but only , as you want or only blank.

    And the last option is to Show the entered comment as a Excel comment with the red triangle symbol, when your mouse hovers on the cell, it displays the comment, like it shows in normal Excel.

    Look in EPM Add-In help for more details



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.