Excel add-in: breaking the connection's cell range

Hi Anaplan Community,

I have a question regarding the Excel add-in. I was reading about refresh conflicts on this Anapedia page.

If you break a connection's cell range, it may not refresh properly. To include a cell range in a Refresh, keep the cell range together at all times, rather than break or split it. You can insert columns and rows in a worksheet and you can rename columns and rows in a worksheet, but you must keep the cell range continuous.

Can anyone explain me what is meant by "breaking the connection's cell range'?

I tried myself by adding a blank column and row (see attachment), but the send & refresh still worked. So it must be something different.

I would like to understand before rolling out the functionality to the end users.

cell range broken.png

Accepted answers

shubhamrawat

Hi @LouiseBourgonjon

In my experience, breaking the cell range sometimes causes issue in data refresh especially in case of large datasets. However, please note that data refresh will not bring any column data that has been removed in the excel. For Example, please see below, here May was removed in the Excel locally, so in the future refreshes the data for May will not populate.

Hope this helps.

-Shubham

All comments

shubhamrawat

Hi @LouiseBourgonjon

Hope this helps.

-Shubham

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…