Question

4
Replies
51
Views
Close popover
Terrell Walker (TerrellW)
Ernst & Young LLP

Ernst & Young LLP
US
View Profile
TerrellW Member since 2017 1 post
Ernst & Young LLP
Posted: October 30, 2018
Last activity: November 20, 2018
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
Close popover
Moderation Team has archived post
Posted: 2 years ago
Close popover
Konstantin Serditov (Konstantin Serditov)
PEGA

Pegasystems Inc.
View Profile

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.

 


Accepted Solution

Posted: 2 years ago
Close popover
Jeff Badger (jeffbadger)
PEGA
Product Manager, Robotics
Pegasystems Inc.
US
View Profile

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.
Share this page Share via LinkedIn Copying...
Copied!