cancel
Showing results for 
Search instead for 
Did you mean: 

Excel formula problem.

DanielLitfeldt
Level 2

Hi, 

I have a problem when posting a formula to excel. Getting an 0x800A03EC error in one case (when posting the original format after changing which cells I'm referring to) and #NAME? error when posting with "," instead of ";" that i tried because of divider problems. Even if i just read then post the formula without manipulate it i get the 0x8... error.

The formula in question: =INDEX(B2:B7;TYPVÄRDE(PASSA(B2:B7;B2:B7;0))) and it works if i post it manually to excel.

Running windows 10 with Swedish language and localization and Swedish excel. 

I need to find a solution since i can't change anything but the language due to not knowing the impact of changing for instance format setting has for the applications I'm using in the automations.

Anyone has any tips regaring this?







------------------------------
Daniel Litfeldt
------------------------------
1 REPLY 1

Hi Daniel,

Not sure what's the root cause from the information provided, but I am listing a few leads to explore.



------------------------------
Pratyush Garikapati
ROM Architect
Blue Prism
Asia/Kolkata
------------------------------