HELP! Anaplan not working

I'm having issues using Anaplan through excel.

I log into Anaplan through excel and I then click on New to open a new pivot table.

At this point, a message appears just below which says "This worksheet does not have a connection to Anaplan."

A second window opens but the window is grey and nothing seems to happen.

Has anyone experienced this issue before and is there a way to resolve this? I need to connect to Anaplan through excel and not through the online link.

Thanks

anaplan_issue_62545.PNG

Accepted answers

All comments

JaredDolich

@hemal

+adding @MagaliP

I've never experienced that particular error but here's some suggestions you might try.

Check to make sure you're on the right version of the Excel Add-In
Logoff and close Excel. Open up Excel again.Log back in.
Make sure you actually have access to the workspace and model you're after by logging on to the Anaplan front door.
Log a ticket with support@anaplan.com

Did your connection work in the past? If so, we just need to figure out what changed.

Anyway, some ideas for you.

Misbah

@hemal

It works perfectly fine for me. Can you try working in different workbook

nathan_rudman

Have you ever successfully connected through the add-in on this network ?

hemal

I have used Anaplan through excel on this version and using these add ins before. I still cannot access Anaplan through excel. I keep getting a blank page pop up and no access to Anaplan. I have tried closing excel, re-installing both Anaplan and office. I can still access Anaplan through the online weblink only.

Misbah

@hemal

It would be wise to raise a ticket with Anaplan Support and let them take a look at it

naushad786

Hi @hemal,

the error shows that you are not connected to the model in your workspace after logged in anaplan through excel.

Please make a New connection as you can see on the top.

Hope, it will help you. Please let me know if you have issue.

Thanks,

Naushad

hemal

When I click on the new connection the same thing keeps happening.

A new pop up tab opens but the tab is grey and I cannot access anything. Anaplan effectively freezes.

Thanks

naushad786

@hemal , can you please attach the screenshot?

hemal

anaplan greyed out.png

naushad786

Hi @hemal,

When you will click New Connection and 2 options will pop up. select one of these and click on it.

After selection you will see new window with workspace and model.

Can you please restart your system and try again ?

Thanks,

Naushad

hemal

This is my issue.

When I click on new, a new window with workspace and model does not open. Instead, I have a grey excel worksheet appear and I cannot access my workbook until I close the greyed out sheet.

naushad786

Hi @hemal,

It might be possibility that you are using two add-ins at the same time. can you please check add-ins in Developer option?

Thanks,

Naushad

MagaliP

Hi,

I have not seen this error before. Could you please email Anaplan Support for investigation?

Thank you very much.

hemal

anaplan add ins.PNG

Snapshot of the add ins I have.

My colleagues also have these Anaplan add ins and there Anaplan works fine.

Thanks

naushad786

Hi @hemal,

Please find the below Add-in screenshot. It is working fine for me and I am using "Anaplan.Excel.Addin64.xll" instead of "Anaplan.Excel.Addin-packed.xll.

It should work for you if your colleagues are using the same add-in.

Now, I would suggest you to contact and report the issue to support@anaplan.com

Thanks,

Naushad

hemal

cool thanks for your help.

Quick Links

Can you help?

Unanswered questions

Request for Workflow Design: End-User Report Finalization & Stakeholder Notification with Version Co
Hi everyone, I'm looking to design a workflow and would appreciate your input or guidance on how to set this up effectively in Anaplan. So, the goal is: Once end users complete their data input, they should be able to trigger a process that: Notifies stakeholders via email with a link to a report. The report includes: A…
Generating Failure Dump - even though no warnings/error in Actions
I've few actions in our Supply model which when run takes some time on the "generating failure dump" step at the end of the action even though the import is a full success without warning or errors. This is just a few seconds when run for a single action, however we have a process with 120 actions, and most of these…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…