I am putting together a dynamic report for submission with the smartview 188.8.131.52. My month is a reference to a cell outside the POV of the smartview
When I do refresh, I still have the reference to this cell but I do SUBMIT the reference is transform by the value, like if someone had done : COPY /PASTE VALUE
=setup!A5 which give March is transform into March
Which version? Check whether you've formula preservation and use excel formatting.
Sorry for such a long response but I was on vacation. I forgot the FORMULA PRESERVATION