# \#excel-formula **URL:** https://forum.uipath.com/tag/excel-formula/2529.md [Latest](https://forum.uipath.com/latest.md) · [Categories](https://forum.uipath.com/categories.md) · [Tags](https://forum.uipath.com/tags.md) --- ## [Unable to run excel workflows parallelly from 2 users](https://forum.uipath.com/t/unable-to-run-excel-workflows-parallelly-from-2-users/5745243)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 11\ **Last updated:** [May 12, 2026, 4:11pm UTC](https://forum.uipath.com/t/unable-to-run-excel-workflows-parallelly-from-2-users/5745243 "2026-05-12T16:11:16Z")
Hello, recently we have faced issue to run automations with excel automation activities parallelly from 2 different users /accounts. our setup - we have total 4 admin users/accounts and we have named user enterprise st… --- ## [For Each: The RPC server is unavailable. (Exception from HRESULT: 0x800706BA)](https://forum.uipath.com/t/for-each-the-rpc-server-is-unavailable-exception-from-hresult-0x800706ba/5744652)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 3\ **Last updated:** [May 8, 2026, 2:32pm UTC](https://forum.uipath.com/t/for-each-the-rpc-server-is-unavailable-exception-from-hresult-0x800706ba/5744652 "2026-05-08T14:32:07Z")
Hello, we are getting this error for for each. we have 4 admin account and named user licenses and we are running automations from all 4 accounts. for one of the script only we are geeting rcp server error multiple ti… --- ## [Read Range: Could not read range A1:S20000](https://forum.uipath.com/t/read-range-could-not-read-range-a1-s20000/5742534)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 2\ **Last updated:** [April 29, 2026, 12:38pm UTC](https://forum.uipath.com/t/read-range-could-not-read-range-a1-s20000/5742534 "2026-04-29T12:38:17Z")
unable to do read range i have build automation previously on classic activities but due to frequent excel issues i am moving to modern so replacing activities with modern activities. getting below error to read range … --- ## [Need to replicate only immidiate next row in excel if row contains specific string](https://forum.uipath.com/t/need-to-replicate-only-immidiate-next-row-in-excel-if-row-contains-specific-string/5738753)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 1\ **Last updated:** [April 15, 2026, 6:45am UTC](https://forum.uipath.com/t/need-to-replicate-only-immidiate-next-row-in-excel-if-row-contains-specific-string/5738753 "2026-04-15T06:45:50Z")
Hello, I have created automation for Jira work orders which fetch tickets from jira with user details using api and work on that and delivers ticket. Automation first checks user id or email id in corp directory first … --- ## [How can i get last row and print in first row](https://forum.uipath.com/t/how-can-i-get-last-row-and-print-in-first-row/5722416)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 5\ **Last updated:** [February 20, 2026, 11:08am UTC](https://forum.uipath.com/t/how-can-i-get-last-row-and-print-in-first-row/5722416 "2026-02-20T11:08:04Z")
Hello, i am writing some data in excel and one it is done i need to get last row of the excel and ned only that data should be remain in excel i first row like below current data in excel - expected output - ho… --- ## [How to remove formula in excel without changing values?](https://forum.uipath.com/t/how-to-remove-formula-in-excel-without-changing-values/5671341)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 2\ **Last updated:** [October 30, 2025, 8:38am UTC](https://forum.uipath.com/t/how-to-remove-formula-in-excel-without-changing-values/5671341 "2025-10-30T08:38:06Z")
Hello, i am applying formula in excel using UiPath. but when i am deleting som columns then values are changing. i need to remove formula and keep values as it is. i need to remove formaul and keep all values even… --- ## [How to calculate sum and write for each specific data](https://forum.uipath.com/t/how-to-calculate-sum-and-write-for-each-specific-data/5670251)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 3\ **Last updated:** [October 28, 2025, 10:55am UTC](https://forum.uipath.com/t/how-to-calculate-sum-and-write-for-each-specific-data/5670251 "2025-10-28T10:55:40Z")
hello , i need expected output like below in excel column value for expected output is calculated using column hours for column project. if you see in project column there are total 3 projects as below and calculat… --- ## [How to calculate and write data in new excel sheet](https://forum.uipath.com/t/how-to-calculate-and-write-data-in-new-excel-sheet/5461729)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 1\ **Last updated:** [September 23, 2025, 12:26pm UTC](https://forum.uipath.com/t/how-to-calculate-and-write-data-in-new-excel-sheet/5461729 "2025-09-23T12:26:28Z")
Hello, we have on eexcel with 2 sheets like below. In sheet 1 , suppose there are 2 users and those are tagged in 2 pojects(DC500,DC400) / 1 project(DC100) that data is there like below. In sheet 2 unique data is t… --- ## [How to select dropdown form excel](https://forum.uipath.com/t/how-to-select-dropdown-form-excel/2790070)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 6\ **Last updated:** [April 17, 2025, 5:18pm UTC](https://forum.uipath.com/t/how-to-select-dropdown-form-excel/2790070 "2025-04-17T17:18:26Z")
Hello, I need to check/varify selcted value in drop down is applicable or not if not then i need to switch to “applicable” means if not applicable is already seelcted then my expected output is - i have more fi… --- ## [Inputting Query formula in excel using UiPath](https://forum.uipath.com/t/inputting-query-formula-in-excel-using-uipath/2745526)
**Author:** [@Komom](https://forum.uipath.com/u/Komom)\ **Replies:** 3\ **Last updated:** [March 4, 2025, 2:52pm UTC](https://forum.uipath.com/t/inputting-query-formula-in-excel-using-uipath/2745526 "2025-03-04T14:52:13Z")
Hi guys I am working on a project and now I have to input a excel query formula (someone written for me) into the advanced editor. I have tried using the “type into” activity but the robot cannot detect the UI element an… --- ## [WRITE FORMULAS IN EXCEL](https://forum.uipath.com/t/write-formulas-in-excel/712357)
**Author:** [@johan.montalvo](https://forum.uipath.com/u/johan.montalvo)\ **Replies:** 6\ **Last updated:** [January 15, 2024, 4:13am UTC](https://forum.uipath.com/t/write-formulas-in-excel/712357 "2024-01-15T04:13:44Z")
Hi guys, i hope you’re well. In this moment i want to write the formula “=HOY()” in a cell, but when i use the follow step in Ui path and write the formula, in Excel appears as in the next capture: What can i do to … --- ## [@ in excel formulas, only when running from orchestrator](https://forum.uipath.com/t/in-excel-formulas-only-when-running-from-orchestrator/706207)
**Author:** [@j.bude](https://forum.uipath.com/u/j.bude)\ **Replies:** 0\ **Last updated:** [December 13, 2023, 2:47pm UTC](https://forum.uipath.com/t/in-excel-formulas-only-when-running-from-orchestrator/706207 "2023-12-13T14:47:36Z")
Hello! I need help with the following issue: I’ve created a workflow where the robot needs to fill in formulas in excel and autofill the rest of the range column. I developed the automation locally and after publishing… --- ## [Get Unique Values only and their sum](https://forum.uipath.com/t/get-unique-values-only-and-their-sum/702455)
**Author:** [@Anjali\_Rani](https://forum.uipath.com/u/Anjali_Rani)\ **Replies:** 8\ **Last updated:** [November 27, 2023, 11:19am UTC](https://forum.uipath.com/t/get-unique-values-only-and-their-sum/702455 "2023-11-27T11:19:01Z")
Hi Guyzz, I was working on one solution ,where i have to add the Price based on the Names and Date , if the date is coming on this month and the name is same then we have to sum up the values and put in different sheet. … --- ## [Excel Automation\> Comparing 2 column and write final value in another column](https://forum.uipath.com/t/excel-automation-comparing-2-column-and-write-final-value-in-another-column/598900)
**Author:** [@anjasing](https://forum.uipath.com/u/anjasing)\ **Replies:** 18\ **Last updated:** [September 21, 2023, 8:50am UTC](https://forum.uipath.com/t/excel-automation-comparing-2-column-and-write-final-value-in-another-column/598900 "2023-09-21T08:50:32Z")
I want to put value in column C/Final color wrt column A/order number and column B/colour. For e.g. same order number will have same color in final color column. But final color value in Final color column for respect… --- ## [How to get exact data like specific column in excel](https://forum.uipath.com/t/how-to-get-exact-data-like-specific-column-in-excel/597660)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 5\ **Last updated:** [September 20, 2023, 2:38pm UTC](https://forum.uipath.com/t/how-to-get-exact-data-like-specific-column-in-excel/597660 "2023-09-20T14:38:42Z")
Hello, my expected data getting B &c column data using 1 api , d column data using 2 nd api and F&G column data using 3 rd api. requirement is i need to generate H column and data should look similar to D column. … --- ## [Excel Formulas when assigned not working](https://forum.uipath.com/t/excel-formulas-when-assigned-not-working/577202)
**Author:** [@P-A-J](https://forum.uipath.com/u/P-A-J)\ **Replies:** 23\ **Last updated:** [August 31, 2023, 12:13pm UTC](https://forum.uipath.com/t/excel-formulas-when-assigned-not-working/577202 "2023-08-31T12:13:54Z")
I am trying to assign a formular to a particular column But i am getting the column in excel as follows. In my excel-\>formulas-\>Correction setting is automatic but still no sign of actual value. --- ## [How to apply formula in excel](https://forum.uipath.com/t/how-to-apply-formula-in-excel/556068)
**Author:** [@Mathkar\_kunal](https://forum.uipath.com/u/Mathkar_kunal)\ **Replies:** 7\ **Last updated:** [June 22, 2023, 5:05am UTC](https://forum.uipath.com/t/how-to-apply-formula-in-excel/556068 "2023-06-22T05:05:32Z")
hello, i need to apply one formula in excel =IF(C2=“”,A2&““&B2,A2&””&B2&“\_”&C2) for one of the column how can i appply? please help me on same. --- ## [How to keep formulas in excel intact while writing into excel](https://forum.uipath.com/t/how-to-keep-formulas-in-excel-intact-while-writing-into-excel/491687)
**Author:** [@Athawale\_Rushikesh](https://forum.uipath.com/u/Athawale_Rushikesh)\ **Replies:** 2\ **Last updated:** [January 3, 2023, 7:20am UTC](https://forum.uipath.com/t/how-to-keep-formulas-in-excel-intact-while-writing-into-excel/491687 "2023-01-03T07:20:16Z")
Hi All, I want to keep excel formulas intact even while writing the excel range. I have an excel file where few cell contains formula, hence when bot write the range, it gets over written with empty cells and formulas … --- ## [Question about exporting formulas in a data table to Excel](https://forum.uipath.com/t/question-about-exporting-formulas-in-a-data-table-to-excel/491837)
**Author:** [@Wing\_Y](https://forum.uipath.com/u/Wing_Y)\ **Replies:** 1\ **Last updated:** [November 19, 2022, 9:43pm UTC](https://forum.uipath.com/t/question-about-exporting-formulas-in-a-data-table-to-excel/491837 "2022-11-19T21:43:18Z")
Hello. I am trying to extract data from an Excel file(e.g. Excel file A) and update it in a data table. The data table will contain data from Excel file A and some formulas. After that, I would like to export the data f… --- ## [Problem triggering Excel formula with a write cell activity](https://forum.uipath.com/t/problem-triggering-excel-formula-with-a-write-cell-activity/457822)
**Author:** [@Geoffroy\_Pantegnies](https://forum.uipath.com/u/Geoffroy_Pantegnies)\ **Replies:** 2\ **Last updated:** [July 20, 2022, 8:24am UTC](https://forum.uipath.com/t/problem-triggering-excel-formula-with-a-write-cell-activity/457822 "2022-07-20T08:24:43Z")
Hello everyone, I have some trouble with Excel, and I was hopping to find a solution here :slight\_smile: When I write with workbook write cell activity a value in Excel, I’m expecting a formula to be triggered as we ca… --- ## [Excel Formula pasted as String issue](https://forum.uipath.com/t/excel-formula-pasted-as-string-issue/392427)
**Author:** [@Chimbu](https://forum.uipath.com/u/Chimbu)\ **Replies:** 9\ **Last updated:** [February 9, 2022, 3:27am UTC](https://forum.uipath.com/t/excel-formula-pasted-as-string-issue/392427 "2022-02-09T03:27:27Z")
I am adding data column with Default value as “=ROW()” to tempDatatable. After that i am writing it to an Excel using Write Range workbook activity. but the excel formula is pasted as String value instead of Row numb… --- ## [Excel - Cannot read range for cell with formula](https://forum.uipath.com/t/excel-cannot-read-range-for-cell-with-formula/387335)
**Author:** [@jhivesh.subron](https://forum.uipath.com/u/jhivesh.subron)\ **Replies:** 2\ **Last updated:** [December 31, 2021, 7:57am UTC](https://forum.uipath.com/t/excel-cannot-read-range-for-cell-with-formula/387335 "2021-12-31T07:57:02Z")
I have an excel workbook. Cell A1 is a fixed value with today’s date and the rest of the cells are populated with a formula (=A1+1, =A2+1). The dates are not recognised by read range workbook because they are populated b…