How to properly use an excel function in an rtf template?
I added an excel function in my RTF template but when the report is created in excel it shows the function and not the result of the function. Is there an solution to this?
- I added a screenshot of my rtf template with the function HYPERLINK. (FYI - it generates a link to another worksheet in the workbook.
- I added a screenshot of the report just after it is generated.
- I added a screenshot of what we expect at the point the report is generated. With a simple edit replace I can get to it but the users are not happy about it.