| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Turn off Excel's 'want to update info?' prompts
Cheers all! I kindly request your help with the following task: I got two Workbooks with Range Names that refer to each other (i.e Range Names in Workbook 1 refer to ranges in Workbook 2, and th opposite). The user will always open Workbook 1 first. I have enabled Workbook 2 to open automatically when Workbook 1 i opened (with the Workbook_Open event). The 'problem': As expected, when I'm opening Workbook 1 (thus causing Workbook 2 t open as well) I'm getting prompts about whether I want to updat Workbook1 with the info on Workbook 2. The same prompt appears when Workbook 2 is opened automatically. The task: Is there any way that the updating takes place automatically in th background for both Workbooks, and no prompts are shown to the user? Thank you very much for your time! Kind regards, Ale -- Alex Hatzisava ----------------------------------------------------------------------- Alex Hatzisavas's Profile: http://www.excelforum.com/member.php...fo&userid=1455 View this thread: http://www.excelforum.com/showthread.php?threadid=26812 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Turn off Excel's 'want to update info?' prompts
in tools=Options, edit tab, unselect Ask to update automatic links.
-- Regards, Tom Ogilvy "Alex Hatzisavas" wrote in message ... Cheers all! I kindly request your help with the following task: I got two Workbooks with Range Names that refer to each other (i.e. Range Names in Workbook 1 refer to ranges in Workbook 2, and the opposite). The user will always open Workbook 1 first. I have enabled Workbook 2 to open automatically when Workbook 1 is opened (with the Workbook_Open event). The 'problem': As expected, when I'm opening Workbook 1 (thus causing Workbook 2 to open as well) I'm getting prompts about whether I want to update Workbook1 with the info on Workbook 2. The same prompt appears when Workbook 2 is opened automatically. The task: Is there any way that the updating takes place automatically in the background for both Workbooks, and no prompts are shown to the user? Thank you very much for your time! Kind regards, Alex -- Alex Hatzisavas ------------------------------------------------------------------------ Alex Hatzisavas's Profile: http://www.excelforum.com/member.php...o&userid=14559 View this thread: http://www.excelforum.com/showthread...hreadid=268123 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Turn off prompts | Excel Discussion (Misc queries) | |||
| How to turn off auto update on a formula | Excel Discussion (Misc queries) | |||
| change info in 1 cell, prompts you for another | Excel Discussion (Misc queries) | |||
| Take info on spreadsheet and turn it in a report | Excel Discussion (Misc queries) | |||
| How do I turn off info box "This document was sent to the printer. | Excel Discussion (Misc queries) | |||
![Alex Hatzisavas[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
