Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
formula/functions for average and if functions | Excel Worksheet Functions | |||
efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
Looking for a site with functions that substitute the ATP functions | Excel Worksheet Functions | |||
Nesting functions in the functions dialog box | Excel Worksheet Functions |