In Anaplan XL, using formulas to pull data (Xl3lookup), how do I stop it calculating all the time? I'm often seeing this message of "working…" despite not having changed anything in my workbook to trigger that.
Thanks,
Tom
Hi Tom,
AXL formula are excel formula a the end of the day. Just like excel formula they will continue to calculate as the workbook is being used. To stop this, you can use the Excel manual calculation mode.
Regarding the working mode, that typically means one of the cells that the calculation is linked to may not have finished computing. Generally, this is because the model was asleep and the calculation paused to not hang up the entire workbook. The solution is to refresh the member formula that will impact your XL3Lookup. This is generally one of the filter cells as below.
A grid offers a great alternative that will avoid this.
Thanks.
Hi, I was hoping to get some help with this situation, where I am trying to take a list to list mapping on the left and get an output similar to the right, but the main idea is i want to be able to make the selected item (format: list), the dimension of a target module and reverse map the original source list as a list…
Hello everyone, I hope you're doing well. I'm posting because two of my coworkers are trying to use the Anaplan Excel Add-In Series 4, but they're running into an issue during the connection setup process. When they go to New → New Read-Only Connection (or New Connection) and reach the "Select a Customer" step, no…
Why in my model output is blank, after send explainability data.
