Jumat, 15 Juli 2016

[smf_addin] Digest Number 3745

4 Messages

Digest #3745

Messages

Thu Jul 14, 2016 7:24 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

"Undefined" typically means you don't have the element definition files in
the same directory as the add-in -- the "smf-elements-n.txt" files. Most of
the element definitions are EXTERNAL to the add-in, for easier update.
That's why the installation instructions says to "extract all of the files
from the ZIP archive".

On Thu, Jul 14, 2016 at 4:48 PM, andrew.hills@hunterfield.com.au
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> Hi Randy, i tried updating your SMF-Template-Yahoo-Analyst-Estimates.xls
> file and received "Undefined&quot; in all the ouput cells. Do you know why?
> Thanks and Regards, Andrew
>

Thu Jul 14, 2016 7:41 pm (PDT) . Posted by:

jkslindsay

Hi Randy.

I, also, have suddenly experienced this issue. No changes to machine / file location; anything.

Windows 10, Excel 2010. Had been working perfectly for (literally) years.

As Don noted, there was an Excel update installed on July 12 that was in response to a "Security Vulnerability" reference: KB3115322:
This security update resolves vulnerabilities in Microsoft Office that could allow remote code execution if a user opens a specially crafted Office file. To learn more about these vulnerabilities, see Microsoft Security Bulletin MS16-088 https://technet.microsoft.com/library/security/MS16-088.

Stewart

Thu Jul 14, 2016 10:06 pm (PDT) . Posted by:

dleeper47

I have exactly the same problem, beginning July 12, with the same cryptic error message. A spreadsheet that had been working fine for years suddenly delivered only "NAME?" values from RCH calls.

I reinstalled the latest version of SMF Add-In files, but the problem persisted.


The add-in appears to load just fine and is checked in the add-ins manager box.


Then I found the following curious "solution"; -- If I uncheck the SMF add-in, update the spreadsheet, then re-check the SMF add-in box, everything starts working again. Great.


But if I save the file and close Excel, then relaunch Excel by clicking on the file, RCH is back to failing. It looks like some sort of security check on Excel start-up might be disabling the add-in on launch, but it can be enabled once Excel is running.


For now, I have a clumsy workaround, unchecking and rechecking the add-in box for SMF, but I'd sure like to find out what's causing the problem.


Any ideas will be much appreciated! I'm using Excel 2010.

Thu Jul 14, 2016 10:10 pm (PDT) . Posted by:

"Randy Harmelink" rharmelink

For those of you having this problem -- where is the add-in located? You
can find out with:

=RCHGetElementNumber("Version&quot;)

On Thu, Jul 14, 2016 at 10:00 PM, dleeper@
​...wrote:

>
> I have exactly the same problem, beginning July 12, with the same cryptic
> error message. A spreadsheet that had been working fine for years suddenly
> delivered only "NAME?" values from RCH calls.
>
> I reinstalled the latest version of SMF Add-In files, but the problem
> persisted.
>
> The add-in appears to load just fine and is checked in the add-ins manager
> box.
>
> Then I found the following curious "solution"; -- If I uncheck the SMF
> add-in, update the spreadsheet, then re-check the SMF add-in box,
> everything starts working again. Great.
>
> But if I save the file and close Excel, then relaunch Excel by clicking on
> the file, RCH is back to failing. It looks like some sort of security check
> on Excel start-up might be disabling the add-in on launch, but it can be
> enabled once Excel is running.
>
> For now, I have a clumsy workaround, unchecking and rechecking the add-in
> box for SMF, but I'd sure like to find out what's causing the problem.
>
> Any ideas will be much appreciated! I'm using Excel 2010.
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar