Hi.

Users of my spreadsheet are opening the file are being asked whether they
want to update links or edit links. I want this box not to appear. I've been
into options but these rules vary from machine to machine. I need some code
that will absoloutley not allow this box or options to show.

I'm eternally grateful to any genius who kindly responds with an equally
genius answer...

Thanks

Gordon

Saved from a previous post:

You can toggle the setting (user by user, though) via:

Tools|Options|Edit Tab.
There's a checkmark for "ask to update automatic links"

But this means that you suppress the question--the links still get updated.

This setting is for the individual user--and affects all their workbooks.

If you want more control:
Try creating a dummy workbook whose only purpose is to open the original
workbook with links updated:

Kind of like:

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

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)

Gordon wrote:

Hi.

Users of my spreadsheet are opening the file are being asked whether they
want to update links or edit links. I want this box not to appear. I've been
into options but these rules vary from machine to machine. I need some code
that will absoloutley not allow this box or options to show.

I'm eternally grateful to any genius who kindly responds with an equally
genius answer...

Thanks

Gordon

--

Dave Peterson

Hi Dave...

Neither of these sit well with what I'm trying to do. I need a bigger stick
to sort this one out so that every user on any machine will never be asked. I
haven't given up hope yet!

Thanks

Gordon...

"Dave Peterson" wrote:

Saved from a previous post:

You can toggle the setting (user by user, though) via:

Tools|Options|Edit Tab.
There's a checkmark for "ask to update automatic links"

But this means that you suppress the question--the links still get updated.

This setting is for the individual user--and affects all their workbooks.

If you want more control:
Try creating a dummy workbook whose only purpose is to open the original
workbook with links updated:

Kind of like:

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

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)

Gordon wrote:

Hi.

Users of my spreadsheet are opening the file are being asked whether they
want to update links or edit links. I want this box not to appear. I've been
into options but these rules vary from machine to machine. I need some code
that will absoloutley not allow this box or options to show.

I'm eternally grateful to any genius who kindly responds with an equally
genius answer...

Thanks

Gordon

--

Dave Peterson

Please post back when you find a better solution.

Gordon wrote:

Hi Dave...

Neither of these sit well with what I'm trying to do. I need a bigger stick
to sort this one out so that every user on any machine will never be asked. I
haven't given up hope yet!

Thanks

Gordon...

"Dave Peterson" wrote:

Saved from a previous post:

You can toggle the setting (user by user, though) via:

Tools|Options|Edit Tab.
There's a checkmark for "ask to update automatic links"

But this means that you suppress the question--the links still get updated.

This setting is for the individual user--and affects all their workbooks.

If you want more control:
Try creating a dummy workbook whose only purpose is to open the original
workbook with links updated:

Kind of like:

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

Then you open the dummy workbook and the links will be refreshed.
(read about that UpdateLinks argument in VBA's help.)

Gordon wrote:

Hi.

Users of my spreadsheet are opening the file are being asked whether they
want to update links or edit links. I want this box not to appear. I've been
into options but these rules vary from machine to machine. I need some code
that will absoloutley not allow this box or options to show.

I'm eternally grateful to any genius who kindly responds with an equally
genius answer...

Thanks

Gordon

--

Dave Peterson


--

Dave Peterson

How much data are you talking? You could write you own code using events to
read / write to the database so there would be no prompting.
Paul D

"Gordon" wrote in message
...
: Hi Dave...
:
: Neither of these sit well with what I'm trying to do. I need a bigger
stick
: to sort this one out so that every user on any machine will never be
asked. I
: haven't given up hope yet!
:
: Thanks
:
: Gordon...
:
: "Dave Peterson" wrote:
:
: Saved from a previous post:
:
: You can toggle the setting (user by user, though) via:
:
: Tools|Options|Edit Tab.
: There's a checkmark for "ask to update automatic links"
:
: But this means that you suppress the question--the links still get
updated.
:
: This setting is for the individual user--and affects all their
workbooks.
:
: If you want more control:
: Try creating a dummy workbook whose only purpose is to open the original
: workbook with links updated:
:
: Kind of like:
:
: Option Explicit
: Sub auto_open()
: Workbooks.Open Filename:="c:\my documents\excel\book2.xls",
UpdateLinks:=1
: ThisWorkbook.Close savechanges:=False
: End Sub
:
: Then you open the dummy workbook and the links will be refreshed.
: (read about that UpdateLinks argument in VBA's help.)
:
: Gordon wrote:
:
: Hi.
:
: Users of my spreadsheet are opening the file are being asked whether
they
: want to update links or edit links. I want this box not to appear.
I've been
: into options but these rules vary from machine to machine. I need some
code
: that will absoloutley not allow this box or options to show.
:
: I'm eternally grateful to any genius who kindly responds with an
equally
: genius answer...
:
: Thanks
:
: Gordon
:
: --
:
: Dave Peterson
:

Hi...

Is there code for not showing dialogue boixes or something like that?

"PaulD" wrote:

How much data are you talking? You could write you own code using events to
read / write to the database so there would be no prompting.
Paul D

"Gordon" wrote in message
...
: Hi Dave...
:
: Neither of these sit well with what I'm trying to do. I need a bigger
stick
: to sort this one out so that every user on any machine will never be
asked. I
: haven't given up hope yet!
:
: Thanks
:
: Gordon...
:
: "Dave Peterson" wrote:
:
: Saved from a previous post:
:
: You can toggle the setting (user by user, though) via:
:
: Tools|Options|Edit Tab.
: There's a checkmark for "ask to update automatic links"
:
: But this means that you suppress the question--the links still get
updated.
:
: This setting is for the individual user--and affects all their
workbooks.
:
: If you want more control:
: Try creating a dummy workbook whose only purpose is to open the original
: workbook with links updated:
:
: Kind of like:
:
: Option Explicit
: Sub auto_open()
: Workbooks.Open Filename:="c:\my documents\excel\book2.xls",
UpdateLinks:=1
: ThisWorkbook.Close savechanges:=False
: End Sub
:
: Then you open the dummy workbook and the links will be refreshed.
: (read about that UpdateLinks argument in VBA's help.)
:
: Gordon wrote:
:
: Hi.
:
: Users of my spreadsheet are opening the file are being asked whether
they
: want to update links or edit links. I want this box not to appear.
I've been
: into options but these rules vary from machine to machine. I need some
code
: that will absoloutley not allow this box or options to show.
:
: I'm eternally grateful to any genius who kindly responds with an
equally
: genius answer...
:
: Thanks
:
: Gordon
:
: --
:
: Dave Peterson
:

Well if I was going to look for a way to suppress the dialog, I would see if
Excel had a registry value that stored the option for showing the updated
linked tables dialog. However, most likely any changes you make to the
registry settings will not take affect until the next time you open Excel.
And for my $0.02, I think it's bad programming to change someones global
settings without changing them back.

My response was to populate the data with your own macro when the user opens
it, this means you do not use a linked sheet and therefore will not get any
dialog promps. Then using the save event write the data back to the
database. You would have to do a lot of data validation so this is no small
task if you are dealing with lots of data.
Paul D

"Gordon" wrote in message
...
: Hi...
:
: Is there code for not showing dialogue boixes or something like that?
:
: "PaulD" wrote:
:
: How much data are you talking? You could write you own code using
events to
: read / write to the database so there would be no prompting.
: Paul D
:
: "Gordon" wrote in message
: ...
: : Hi Dave...
: :
: : Neither of these sit well with what I'm trying to do. I need a bigger
: stick
: : to sort this one out so that every user on any machine will never be
: asked. I
: : haven't given up hope yet!
: :
: : Thanks
: :
: : Gordon...
: :
: : "Dave Peterson" wrote:
: :
: : Saved from a previous post:
: :
: : You can toggle the setting (user by user, though) via:
: :
: : Tools|Options|Edit Tab.
: : There's a checkmark for "ask to update automatic links"
: :
: : But this means that you suppress the question--the links still get
: updated.
: :
: : This setting is for the individual user--and affects all their
: workbooks.
: :
: : If you want more control:
: : Try creating a dummy workbook whose only purpose is to open the
original
: : workbook with links updated:
: :
: : Kind of like:
: :
: : Option Explicit
: : Sub auto_open()
: : Workbooks.Open Filename:="c:\my documents\excel\book2.xls",
: UpdateLinks:=1
: : ThisWorkbook.Close savechanges:=False
: : End Sub
: :
: : Then you open the dummy workbook and the links will be refreshed.
: : (read about that UpdateLinks argument in VBA's help.)
: :
: : Gordon wrote:
: :
: : Hi.
: :
: : Users of my spreadsheet are opening the file are being asked
whether
: they
: : want to update links or edit links. I want this box not to appear.
: I've been
: : into options but these rules vary from machine to machine. I need
some
: code
: : that will absoloutley not allow this box or options to show.
: :
: : I'm eternally grateful to any genius who kindly responds with an
: equally
: : genius answer...
: :
: : Thanks
: :
: : Gordon
: :
: : --
: :
: : Dave Peterson
: :
:
:
: