Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Wonderware Active Factory Add In Problem
I am using a function from active factory called wwWideHistory2( ). It is an
array formula that looks something like this: {=wwWideHistory2( ....)}. In order for this function to work i have to have the active factory excel add in installed. The function is working fine. The problem is that sometimes when excel starts up (i'm using excel 2007 and the file is a 2003 file format) the above mentioned function with get replaced with {='P:\Program Files\Common Files\ArchestrA\HistClient.xla'!wwWideHistory2( ....)} because i'm assuming it can't find the add in workbook. When the function looks like this is doesn't work at all. So if i edit the cell and take out the reference to the external file after excel is open, everything works fine again. Is there any way to disable excel from making this external file reference on its own or do i have a different problem that i need to address? |
#2
|
|||
|
|||
Joe,
I am having the same issue with activefactory add in. Did you ever find a solution? Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referring to formula in a non active cell from active cell | Excel Discussion (Misc queries) | |||
HELP PLEASE! I NEED TO TELL THE FACTORY WHAT TO MAKE USING EXCEL!! | Excel Discussion (Misc queries) | |||
How to reset Excel 2000 toolbars to "factory defaults"? | Excel Discussion (Misc queries) | |||
HOW TO COPY 480 ACTIVE E-MAIL ADDRESSES CLM "G" ON AN ACTIVE EXCE. | Excel Discussion (Misc queries) |