https://community.blueprism.com/t5/Product-Forum/writing-excel-formulas-with-blueprism-ends-in-NAME-error-in-the/m-p/66117#M18722 This might be a locale issue. I assume the function "SUMME" is the German version of SUM? I've just tested writing a summation formula to a cell (=SUM(A1:B1)) to a cell and it worked fine.<BR /><BR />What version of Blue Prism are you using?<BR /><BR />Cheers,<BR /><BR />------------------------------<BR />Eric Wilson<BR />Director, Partner Integrations for Digital Exchange<BR />Blue Prism<BR />------------------------------<BR /> Fri, 13 Nov 2020 14:37:00 GMT ewilson 2020-11-13T14:37:00Z https://community.blueprism.com/t5/Product-Forum/writing-excel-formulas-with-blueprism-ends-in-NAME-error-in-the/m-p/66116#M18721 <P>I have an excel file that I open with blueprism to add some simple data like text and formulas in certain cells.</P> <P>I use <STRONG>get excel sheet as collection</STRONG> action for this and then I loop through the collection and edit certain "cells" of the collection.</P> <P>For exporting back to excel I use the <STRONG>write collection</STRONG> action.</P> <P>I tried writing these texts by using a simple calculation stage and also the <STRONG>set cell value</STRONG> action. Unfortunately both ways of writing the text bring the same result once I open the file in excel.</P> <UL> <LI>writing simple text into a cell works</LI> <LI>writing simple formulas in a cell e.g. =L2 works</LI> </UL> <P>But when I write a formula like: =SUMME(L2:L4) into a cell Excel displays <STRONG>#NAME?</STRONG> in the cell when I open then excel file to see the result. (see screenshot)</P> <P>When I double click the cell with the #NAME? in it, excel suddenly acknowledges the formula and switches the #NAME? to the correct result of the formula.</P> <P><A href="https://i.stack.imgur.com/qVrcW.png" rel="nofollow noreferrer">screenshot of excel result</A></P> <P>My questions are:</P> <P>Is there a way to write formulas with blueprism that the #NAME? error does not happen ?</P> <P>Is there a way to force excel to refresh the #NAME? cells so that the formula appears and I dont have to doubleclick every cell that has #NAME? in it ?</P> --------------------------------------------------<BR /> <B>Disclaimer:</B> This content was auto-posted from Stackoverflow. The original Stackoverflow question is here <A href="https://stackoverflow.com/questions/64783456/writing-excel-formulas-with-blueprism-ends-in-name-error-in-the-excel-file">Stackoverflow Post</A>, posted by <A href="https://stackoverflow.com/users/14617932/marco">Marco</A>. Thu, 12 Nov 2020 09:01:00 GMT https://community.blueprism.com/t5/Product-Forum/writing-excel-formulas-with-blueprism-ends-in-NAME-error-in-the/m-p/66116#M18721 Digital_WorkerB 2020-11-12T09:01:00Z https://community.blueprism.com/t5/Product-Forum/writing-excel-formulas-with-blueprism-ends-in-NAME-error-in-the/m-p/66117#M18722 This might be a locale issue. I assume the function "SUMME" is the German version of SUM? I've just tested writing a summation formula to a cell (=SUM(A1:B1)) to a cell and it worked fine.<BR /><BR />What version of Blue Prism are you using?<BR /><BR />Cheers,<BR /><BR />------------------------------<BR />Eric Wilson<BR />Director, Partner Integrations for Digital Exchange<BR />Blue Prism<BR />------------------------------<BR /> Fri, 13 Nov 2020 14:37:00 GMT https://community.blueprism.com/t5/Product-Forum/writing-excel-formulas-with-blueprism-ends-in-NAME-error-in-the/m-p/66117#M18722 ewilson 2020-11-13T14:37:00Z