Pivot in Nprinting Report

[muslikhahmasbah]

I am not able to do data reference from a pivot in NPrinting. 

The pivot contain column that have long formula for aging. 

I received below error when i try to do data reference. 

"Text values in formulas are limites to 255 characters. To create loongre text values in a formula, use the Concatenate function or the concatenate operator (&)"

Seeking expertise advice here. 

Thank you

[Lech_Miszkiewicz]

This is not NPrinting issue!!!

it is well known and widely described excel single cell limitation.. some examples in links below:

https://www.mrexcel.com/board/threads/formula-character-limit.460599/

ot here:

https://stackoverflow.com/questions/12386414/excel-use-formula-longer-that-255-characters

or here:

https://stackoverflow.com/questions/43524741/excel-formula-limitation-with-255-characters-with-if-st...

Depending on your use case there is a lot what can be done, but If you want us to give yo umore advice it will require your to provide us with everything needed to replicate this issue so we could test it in our own environmnets. Some sample app, maybe export of the template, screenshots etc....