ps. That number will change based on the version of excel that you're using.

xl2003 is version 11.0 and xl2007 is xl2007.

Starrmann wrote:

Hello!

I have developed an Excel add-in for a customer. The add-in enables
users to retreieve data from a database by using WorkSheet formulas.

The User writes in a cell
=Quote('31/12/2009';'MSFT')
and Microsofts stock quote shows up.

Some users in the company does not have the add-in installed.
When using Office 2003 and opening up a workbook using the formulas,
they were still able to see the values in the cell, provided that just
clicked no when asked to update external links.

After uppgrading to Office 2007 users without the component are no
longer able to see the quotes, even when they don't update links.
Instead #VALUE is displayed.

In the cell the formula has changed to
='C:\Program Files\QuoteManager\qm.xla'!Quote('31/12/2009';'MSFT')

This is where the add-in is installed normally.

Why doesn't it work anylonger?

The workbook is still saved as xls, not xlsx!

--

Dave Peterson