Add-in functions

[dbustell]

I have an Excel Add-in connected to plant equipment on a machine running
Excel 2003.

When I open the spreadsheet with Excel 2003 on a machine that does NOT have
the add-in, the file opens with the last values recorded by the original
machine.

When I open the spreadsheet with Excel 2007 on a machine that does not have
the add-in, the file opens with #NAME? in all of the cells using the add-in
functions.

How can I make Ex2007 open the file and ignore the addin functions?

TIA
Donald

 

[Shane Devenshire]

Hi,

Probably need to rewrite the add-in.

 

[dbustell]

Not an option - It belongs to the industrial equipment supplier.
The problem is with the behavior of Excel - not the addin.
Thx
D-

 

[JLatham]

I would at least report the issue to the industrial equipment supplier - they
need to be aware of it so they can work with MSFT to get things working
properly.

Have you tried going into the Add-Ins manager in Excel 2007 and seeing what
you can do there? Office Button --> [Excel Options] --> Add-Ins

I'm not sure, but I suppose that your issue is that you're taking files from
the 'special system' and sending it to others that don't have the add-in for
further use? Is there a licensing or other issue with installing the add-in

 

[Dave Peterson]

I don't recall if I've tested this in xl2007 (or what happened when/if I did)...

There is a windows registry setting that can be changed so that newer versions
of excel recalculate these links in the same manner that earlier versions of
excel used.

Jim Rech posted this:
http://groups.google.com/[email protected]

Maybe it'll work for you.

====
But if I had to share a workbook that had those custom functions with a user who
didn't have those custom functions, I wouldn't rely on this. I'd convert those
formulas to values and share that version of the workbook.

I'd be afraid that the user without the addin would cause excel to recalc and
still end up with those name errors.

 

[Dave Peterson]

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

xl2003 is version 11.0 and xl2007 is xl2007.

 

[dbustell]

The spreadsheet is on a machine at our plant in Omaha. The addin reads
equipment at the plant. The sheet is saved via VPN to a server in Des Moines.
The machines in Des Moines have no contact with the plant equipment.

When a 2003 machine in DM opens the file, the numbers are there.
When a 2007 machine in DM opens the file, it barfs.

2007 is doing some kind of validation on opening that 2003 doesn't do.
That's the trigger I'm looking for.

Thx
D-

I would at least report the issue to the industrial equipment supplier - they
need to be aware of it so they can work with MSFT to get things working
properly.

Have you tried going into the Add-Ins manager in Excel 2007 and seeing what
you can do there? Office Button --> [Excel Options] --> Add-Ins

I'm not sure, but I suppose that your issue is that you're taking files from
the 'special system' and sending it to others that don't have the add-in for
further use? Is there a licensing or other issue with installing the add-in

Not an option - It belongs to the industrial equipment supplier.
The problem is with the behavior of Excel - not the addin.
Thx
D-