About Thomas.Rickels

Thomas.Rickels · ‎09-10-2020

I've recently been having an issue with the Excel-Add In wiping out all my formulas outside of the refreshed data range. Typically when I have refreshed the tab from Anaplan I can update my anaplan filter and refresh the data without any data or formula loss as long as it's outside the range of the refreshed cells. Any idea why this may be occurring in this instance?

Thomas.Rickels · ‎05-19-2020

I've had this import error before when I was doing a model to model import with some fairly large modules. The only way I could get it to work is to manually map the line items I needed and then importing. By doing it this way I was able to get around the Illegal argument issue. That said, by no means is this a solution and I would contact Anaplan support as it's been a pending issue to be resolved for me as well.

Thomas.Rickels · ‎05-18-2020

If you ever want to take it one step further and would like to automate the mapping. Keep in mind this can only be done if your database provides data to make the relationship. If you have a database that matches the selective field and employee name in a row of data. You can import multiple members into the boolean fields as mentioned by Nathan.

About Thomas.Rickels

Excel Add In 3.0 Formula Wipeout

Re: Import Error

Re: User access automation for multiple selective ...

Re: User access automation for multiple selective ...

Re: User access automation for multiple selective ...

Re: User access automation for multiple selective ...

Excel Add-in for Mac

Re: Best Practices for Module Design

Clear multiple cells (NUX)

New UX - Add external web links for Images

Allow for line item subset to be more than just nu...