Updateing file links
 

I've got a macro in which I update a series of filenames that are
linked to about three thousand cells in my workbook, but I would like
to be able to update the links with names of files that don't exist,
but when I run the macro in that fashion, it displays a pop-up box
asking me to find the linked files. Is there anyway to deactivate
this pop-up box?

Updateing file links
 

I'm not sure what you're doing specifically, but this technique has worked for
me in the past.

Say I'm filling a column with a formula that I want to point at a file that
doesn't exist.

I can fill that column with text instead.

Instead of starting with an equals sign, I start with $$= (forcing the entry to
be text).

Then I run data|text to columns (or the equivalent in the ribbon).

And chop off that leading $$ leaving the formula.

You may want to try it on a small amount of formulas -- just in case it doesn't
work.

On 12/06/2010 14:46, Winkler707 wrote:
I've got a macro in which I update a series of filenames that are
linked to about three thousand cells in my workbook, but I would like
to be able to update the links with names of files that don't exist,
but when I run the macro in that fashion, it displays a pop-up box
asking me to find the linked files. Is there anyway to deactivate
this pop-up box?

--
Dave Peterson

Updateing file links
 

ps.

Selecting the range
and using Edit|Replace
what: $$
with: (leave blank)
replace all

Will cause the dialog to appear, so that's a non-starter, too.

On 12/06/2010 18:12, Dave Peterson wrote:
I'm not sure what you're doing specifically, but this technique has worked for
me in the past.

Say I'm filling a column with a formula that I want to point at a file that
doesn't exist.

I can fill that column with text instead.

Instead of starting with an equals sign, I start with $$= (forcing the entry to
be text).

Then I run data|text to columns (or the equivalent in the ribbon).

And chop off that leading $$ leaving the formula.

You may want to try it on a small amount of formulas -- just in case it doesn't
work.

On 12/06/2010 14:46, Winkler707 wrote:
I've got a macro in which I update a series of filenames that are
linked to about three thousand cells in my workbook, but I would like
to be able to update the links with names of files that don't exist,
but when I run the macro in that fashion, it displays a pop-up box
asking me to find the linked files. Is there anyway to deactivate
this pop-up box?


--
Dave Peterson