#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Add-in functions

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
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,346
Default Add-in functions

Hi,

Probably need to rewrite the add-in.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"dbustell" wrote:

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

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Add-in functions

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

"Shane Devenshire" wrote:

Hi,

Probably need to rewrite the add-in.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"dbustell" wrote:

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

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default Add-in functions

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
on other systems?

"dbustell" wrote:

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

"Shane Devenshire" wrote:

Hi,

Probably need to rewrite the add-in.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"dbustell" wrote:

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

  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Add-in functions

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/groups?thre...GP11.phx .gbl

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.

dbustell wrote:

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


--

Dave Peterson


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Add-in functions

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

xl2003 is version 11.0 and xl2007 is xl2007.

Dave Peterson wrote:

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/groups?thre...GP11.phx .gbl

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.

dbustell wrote:

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


--

Dave Peterson


--

Dave Peterson
  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Add-in functions

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-

"JLatham" wrote:

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
on other systems?

"dbustell" wrote:

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

"Shane Devenshire" wrote:

Hi,

Probably need to rewrite the add-in.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"dbustell" wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to convert cell formula functions to code functions Adnan Excel Discussion (Misc queries) 1 October 1st 08 08:30 PM
formula/functions for average and if functions Petu71 Excel Worksheet Functions 2 August 5th 07 08:25 PM
efficiency: database functions vs. math functions vs. array formula nickname Excel Discussion (Misc queries) 2 July 14th 06 04:26 AM
Looking for a site with functions that substitute the ATP functions Franz Verga Excel Worksheet Functions 3 June 24th 06 04:30 AM
Nesting functions in the functions dialog box cs170a Excel Worksheet Functions 0 June 10th 05 10:36 PM


All times are GMT +1. The time now is 01:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"