You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to properly use an excel function in an rtf template?

Received Response
21
Views
3
Comments

Summary:

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?

Content (required):

  1. I added a screenshot of my rtf template with the function HYPERLINK. (FYI - it generates a link to another worksheet in the workbook.
  2. I added a screenshot of the report just after it is generated.
  3. 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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!