INFORMATIONAL ** THIS INFORMATION HAS NOT BEEN VERIFIED **

Formulas are not replaced with Values when using the ExtendFormulaeToUsedRows Add-In and the Excel Range to copy is more than one column

Entry Type: Informational

Product: Sage MAS Intelligence

Application: SMI Report Manager 

Version Reported: 7.30 

Subject:

Formulas are not replaced with Values when using the ExtendFormulaeToUsedRows Add-In and the Excel Range to copy is more than one column.

Possible Resolution:

1. Expand MAS Intelligence, Tools, Report Manager.
2. Copy any report and paste into a new folder.
3. Highlight the copied report and select 'Show Advanced' on the 'Properties' tab.
4. Click the 'Run Add-Ins' ellipse button.
5. Select Alchemex Add-in 1 from the 'Select Add-In Library' drop-down.
6. Select General Excel extensions Module from the 'Select Add-In Library Module' drop-down.
7. Click on 'ExtendFormulaeToUsedRows' and click 'OK'. Note the Description of this Function "Name: ExtendFormulaeToUsedRows - Description : Extends formulae in a range to the specified area - Use When : You wish to apply formulae to a dynamic row range "
8. Enter Destination Sheet (Example "Sheet1").
9. Enter 'The Column To begin at (Number)'. Enter 'The first row to begin copying to'.
10. Enter 'The Excel Range".
11. Enter 'The Column used to define the used row range'.
12. Select YES for the 'Replace the Formulae with Values'.
13. Enter a 'End Column (Number)'

Note: Step 13 is important. If the end column number is not defined then the Formulas will not be replaced with values for the entire Excel Range defined in Step 10.