Showing results for 
Search instead for 
Did you mean: 

XL reporter: How to return values only to worksheet?

Former Member
0 Kudos


In the intrest of distributing report results to computers where macros are not allowed, is there any way to return actual cell values to reports instead of the ixGet("xyz") or SUM(ixRange1)? You can create a macro to copy and paste values, but I could not get it automatically run when opening the workbook. Any hints or more clever solutions for the problem?


Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi, Tomi,

Macro is mandatory to run XLR. That is the bridge to translate all formula to values.

You can try to open XLR in macro allowed Excel and copy value only to get new report for those Excel without macro.