0

The formula cannot be quoted

Yvonne Jury

December 15, 2017 18:32

None

Follow

Is there any way to get around this error?:

The formula cannot be quoted. Excel formulas cannot contain text values greater than 255 characters in length.

• Facebook
• Twitter
• LinkedIn

2 comments

• 0
  
  Harry Lewis December 15, 2017 20:07

  Hello Yvonne -

  That is a limitation in Excel.  If you are using Dynamics NAV and your formula includes table or field names, you could use the table or field numbers, instead, to help shorten.

• 0
  
  Yvonne Jury December 15, 2017 20:22

  My formula contains the table and column numbers instead of names, and it's still too long. I'll have to figure out something else.