Anaplan Excel Add-In 3.3 (Read/Write Query)

Hi all,

I understand the ability to create a read/write connection with Anaplan was reintroduced in v3.3 of the Excel add-in.

Where does this feature reside? I am using v3.3.44.0 and below is a screenshot of my toolbar;

I have full access and workspace admin permissions, I also have write access enabled on the version and module I am trying to write into.

Best,

Callum

Accepted answers

Misbah

@CallumW

Yes before you go to that screen it should give you two options and once you make your choice then this screen should pop up.

You get that option as soon as you hover over "New" command. If not, it is best you log in a ticket with Anaplan support and share the feedback with the community.

Hope that helps.

Misbah

MagaliP

Hi @CalGW ,

There is a known issue about this: https://community.anaplan.com/t5/Known-Issues-and-Workarounds/Excel-V3-3-Unable-to-create-a-read-write-connection/m-p/55099#M104

I hope this helps

All comments

Misbah

@CallumW

When you click on " New" - creating a new connection it should give these two options

Misbah

CallumW

Hi @Misbah

When I click on new I am prompted with the following screen;

Should it appear before this?

Best,

Callum

Misbah

@CallumW

Yes before you go to that screen it should give you two options and once you make your choice then this screen should pop up.

You get that option as soon as you hover over "New" command. If not, it is best you log in a ticket with Anaplan support and share the feedback with the community.

Hope that helps.

Misbah

CallumW

I see, it seems I am not getting that prompt unfortunately.

Just wanted to check on the community before I contacted support - thanks for the help @Misbah !

Best,

Callum

MagaliP

Hi @CalGW ,

There is a known issue about this: https://community.anaplan.com/t5/Known-Issues-and-Workarounds/Excel-V3-3-Unable-to-create-a-read-write-connection/m-p/55099#M104

I hope this helps

CallumW

Thanks @MagaliP !

Quick Links

Can you help?

Unanswered questions

How to create Anaplan formula MTD with Input Date
Hi, I'm trying to create a month to date line that is based on a specific input date, not the actual date. Is this possible?
How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…