Hi everyone! I’m facing a weird fact in processing my robot, I’ll try to explain. I want to automate a very technical process for a client that, in the final phase, makes use of an add-inn installed on Excel. This add-inn simply introduces a new set of formulas which extrapolate figures and data f…

Hi @Vivek_Arunagiri , thanks for your reply. I have already tried this way. I have also tried to add a send hotkey activity Alt+mb, which should be the same, but nothing.

Or use the send hotkey activity to navigate the ribbon. This example does what you need with a simple example and it works. I set the options on excel to only update formulas when the it is called. RefreshCalculations.zip (8.3 KB) Your error suggest some kind of formula syntax issue within the ex…

Try click activity on Calculate now button under formula tab. [image]

Hi @ronanpeter , thanks for your reply. Yes, the cell that I update is an argument of the formulas I want refresh.

Have you tried attaching a simple Macro to the file and calling that? recalculate all open workbooks Application.Calculate recalculate a specific worksheet Worksheets(1).Calculate recalculate a specific range Worksheets(1).Columns(1).Calculate

[image] D3BO_C3PO: Yes, the cell that I update is an argument of the formulas I want refresh In that case try the following. This rechecks dependent formulas before recalculating. It is sending hotkey shift+ctrl+alt+f9 to do so. RefreshCalculations2.zip (59.9 KB)

I tried to adopt both RefreshCalculation.zip and RefreshCalculation2.zip model. The result is always the same: nothing. I’m starting to think there is something wrong (eg an optional flag marked in the Excel Option panel) in the template file. Responding to your previous suggestion: yes, I have alr…

Keep a break point at Refresh and debug. When bot is at break point, check if the formula is correct.

Excel refreshing formulas

Help

Vivek_Arunagiri (Vivek Arunagiri) May 15, 2019, 9:02am 2

Hi @D3BO_C3PO,

You can give shortcut “F9” to refresh the formula manually.

Please refer this link.

Topic		Replies	Views
Excel formula Refresh Activities excel	3	1345	February 11, 2022
Excel issue - refreshing cells Academy Feedback	9	1161	February 28, 2020
How Can I Recalculate An Excel Workbook without using a Macro or Send Hotkeys Studio excel , uiautomation	4	1139	April 15, 2022
Can we perform Refresh operation on excel file? Help activities	2	4475	December 21, 2018
Update formula in excel - #name? Studio studio , question , activities_panel	4	1035	April 6, 2021

Excel refreshing formulas

Related topics