Get Dialog saying it cannot update links (I have created an Add-in)

[eholz1]

Hello Newsgroup,

I have created an add-in in MS Excel 2003. I am using the pull
function created by Harlan Grove. I copied his code into an xls file,
named it PullFunction.xla and saved it as an xla file. An Add-in if
you prefer.

I then have added this new add-in to a workbook, and can use the pull
function, and it does indeed pull data from a closed workbook. I have
the problem when I try to open the workbook that contains the function
after closing it. I get a dialog that says "would I like to update
the links" etc. I click the "Yes" button, and then get a dialog that
says it cannot find the file (the addin), but it does show the xla
file. in my case it is Pullfunction.xla.
I just select that file, and click OK, and it goes to the workbook and
the worksheet.

Is there a way to get around this mulitple dialog thing?

Thanks for any tips,

eholz1

 

[Dave Peterson]

Just a guess...

I'm guessing that you changed the location of that addin after you created the
workbook that uses it.

I'd open the workbook, say no to the prompt and inspect the cells with the
=pull() function.

I'm guessing that the formula you see in those cells won't be pointing at the
actual path that contains your pullfunction.xla addin.

I'd fix those formulas so that they point at the correct path. Save and close
the workbook, then test it by reopening.

And a second guess...

If you think you did this already (change to the correct path), then maybe you
missed a cell that has that function from the old location.

I would use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

to help me find those cells if I couldn't find them myself.

 

[eholz1]

Just a guess...

I'm guessing that you changed the location of that addin after you created the
workbook that uses it.

I'd open the workbook, say no to the prompt and inspect the cells with the
=pull() function.

I'm guessing that the formula you see in those cells won't be pointing atthe
actual path that contains your pullfunction.xla addin.

I'd fix those formulas so that they point at the correct path.  Save and close
the workbook, then test it by reopening.

And a second guess...

If you think you did this already (change to the correct path), then maybe you
missed a cell that has that function from the old location.

I would use Bill Manville's FindLink program:http://www.oaltd.co.uk/MVP/Default.htm

to help me find those cells if I couldn't find them myself.

Hello Dave,

I checked out your suggestions. The findlink program did not help in
this case. I had those pretty well in hand. I did some more searching
on the web, and found a statement (from the MSDN site) that if I want
my Addin to load, place it in the XLSTART folder. I placed my xla file
in that folder, and that seemed to clear things up. But that does not
explain why the findlink.xla and the ASAP utilities.xla work perfectly
every time! and those files are NOT in the XLSTART folder. Perhaps my
code in my Add-in requires some extra lines, etc.
Thanks,

eric

 

[Dave Peterson]

Putting a workbook in your XLStart folder is one way to make sure it's opened
when excel starts. But it's not the only way.

When you opened the workbook and answered no to the prompt, what drive/folder
did the formulas that used the =pull() function want to use?

If the original addin was in this location, then you moved it to the XLStart
folder, that could be the cause of the "file not found" error when trying to
update the links.