In RPA LE how do perform a Data / Refresh All? I have tried targeting the menu bar and sending [^Alt+A+R+A] but sometimes it doesn’t trigger. Is there are way to make it refresh all? I tried using an Excel macro but I also have to enter user/pass credentials and RPA won’t give control back until the macro is done.
Solved
How to Data / Refresh All in RPA LE
+1Best answer by nicknep
Hi AlanWard,
I have also seen inconsistency when sending 3 or more keyboard presses from a single action. Here’s a couple of workarounds you can try:
- Send the Excel shortcut for Refresh All, [^Ctrl+Alt+F5]. When setting up this action, ensure you target Excel (not the workbook), and set the keyboard mode to None and speed to Slow.
- Split the single action into multiple send values, and include a wait of .5 seconds between each. This will allow Nintex to slowly press each keystroke, ensuring it doesn’t mistype.
Let me know if this helps!
-Nick
+1Hi AlanWard,
I have also seen inconsistency when sending 3 or more keyboard presses from a single action. Here’s a couple of workarounds you can try:
- Send the Excel shortcut for Refresh All, [^Ctrl+Alt+F5]. When setting up this action, ensure you target Excel (not the workbook), and set the keyboard mode to None and speed to Slow.
- Split the single action into multiple send values, and include a wait of .5 seconds between each. This will allow Nintex to slowly press each keystroke, ensuring it doesn’t mistype.
Let me know if this helps!
-Nick
+1Thanks for the suggestion. 1. seemed to work. I couldn’t get 2. to work because it was like the bot was cilcking and releasing during the wait… it wasn’t “holding down the keys”.
+10- Nintex Employee
- 30 replies
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.