Question

4
Replies
74
Views
 Terrell Walker (TerrellW)
Ernst & Young LLP

Ernst & Young LLP
US
TerrellW Member since 2017 1 post
Ernst & Young LLP
Posted: October 30, 2018
Last activity: February 17, 2021
Posted: 30 Oct 2018 11:29 EDT
Last activity: 17 Feb 2021 10:12 EST
Closed
Solved

Excel Pop-Up Manipulation

Hey All,

I am working on a solution that requires excel manipulations with some formulas within the spreadsheets and am encountering a pop-up after opening a file containing formulas. Does anyone know the best way to manipulate pop ups within excel currently?

Robotic Process Automation
Moderation Team has archived post, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.
Posted: 2 years ago
Posted: 30 Oct 2018 12:29 EDT
Konstantin Serditov (Konstantin Serditov)
PEGA

Pegasystems Inc.

Hi,


You can disable this pop-up:

Show More

Hi,


You can disable this pop-up:


  1. Click File, and then click Options.

  2. Click Advanced.

  3. Under General, click to clear the Ask to update automatic links check box.

 




Show Less

Accepted Solution

Posted: 2 years ago
Posted: 30 Oct 2018 12:29 EDT
Jeff Badger (jeffbadger)
PEGA
Product Manager, Robotics
Pegasystems Inc.
US

In build 8.0 SP1 2010 which will be released shortly you will have a property on the Excel connector called AskToUpdateLinks.  If you set this to false the popup should not be displayed.



In this release there are over 40 new methods on the Excel connector.