Dialogue box in EXCEL

  • Thread starter Thread starter Marisol V.
  • Start date Start date
M

Marisol V.

Hello,

I have an EXCEL worksheet that has data links to other
sheets. Everytime I access this file I get a dialogue box
asking me if I would like to update the spreadsheet. I do
not want to update the spreadsheet. I want to keep the
data as is but would like to omit having to say "no" to
the dialogue box everytime I access the spreadsheet.

Is there way to omit the dialogue box without affecting
the data on the spreadsheet.

Any suggestions?
 
You should be able to do this by: Tools, Options, and in the Calculation
tab, de-select "Update remote references," then in the Edit tab, de-select
"Ask to update automatic links."

MRO
 
FYI:

This setting controls references to other (not Excel) applications, so it
has no impact here.

If you uncheck this Excel will automatically try to update links and, if it
cannot find a linked file, will display an error message. So you cannot
have (1) no alert and (2) no update.
 
In xl2002, there's an option under Edit|links|Startup Prompt Button that allows
you to specify how to treat the links:

1. Let the users decide
2. don't display and don't update
3. don't display, but do update

In earlier versions, you could have another workbook that you open that tells
excel not to try to update your links.

You could have a "dummy" workbook whose only function is to open your workbook
and not update links. Then it closes itself to get out of the way:

Option Explicit
Sub auto_open()
Workbooks.Open Filename:="c:\my documents\excel\book2.xls", UpdateLinks:=0
ThisWorkbook.Close savechanges:=False
End Sub

(Look at VBA's help for workbooks.open to find other options for updatelinks.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
Back
Top