Sabtu, 02 Desember 2017

[smf_addin] Digest Number 4253

6 Messages

Digest #4253

Messages

Fri Dec 1, 2017 10:37 pm (PST) . Posted by:

"Robbie Geary" rgearyiii

Every since I tried out another Excel add-in, Excel 2016 keeps forgetting
to load the SMF add-in. By that I mean in order to get SMF to work, I have
to disable it and then re-install it by browsing back to its original
location (Excel seems to keep a copy of it in my user files) every time I
start Excel.

Has anyone else ever had this problem, and if so, how did you fix it?

Thanks

--
Robbie Geary

Fri Dec 1, 2017 11:42 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

This may be the issue that first occurred in July of 2016 because MicroSoft
issued some security updates. It's not letting EXCEL load the add-in when
EXCEL starts up.

For a workaround suggested by Microsoft, until they supposedly fix the
issue, see:

https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568

But your issue sounds like it may be something else? You could try this
process:

1. Go to the add-in manager, uncheck the SMF add-in to deactivate it
2. Exit EXCEL (this hopefully will clear any pointers to the add-in)
3. Restart EXCEL
4. Go to the add-in manager, reactivate the SMF add-in using the "Browse"
option
5. Exit EXCEL (to save the new install)
6. Restart EXCEL
7. Use this formula to make sure everything looks like you expect (it's
loaded, folder location, version, etc):

=RCHGetElementNumber("Version")

On Fri, Dec 1, 2017 at 11:37 PM, Robbie Geary rgearyiii@
​...
wrote:

>
> Every since I tried out another Excel add-in, Excel 2016 keeps forgetting
> to load the SMF add-in. By that I mean in order to get SMF to work, I have
> to disable it and then re-install it by browsing back to its original
> location (Excel seems to keep a copy of it in my user files) every time I
> start Excel.
>
> Has anyone else ever had this problem, and if so, how did you fix it?
>
>

Sat Dec 2, 2017 2:16 am (PST) . Posted by:

"Robbie Geary" rgearyiii

What you've outlined is exactly what I've been trying.

On Sat, Dec 2, 2017 at 6:42 PM, Randy Harmelink rharmelink@gmail.com
[smf_addin] <smf_addin@yahoogroups.com> wrote:

>
>
> This may be the issue that first occurred in July of 2016 because
> MicroSoft issued some security updates. It's not letting EXCEL load the
> add-in when EXCEL starts up.
>
> For a workaround suggested by Microsoft, until they supposedly fix the
> issue, see:
>
> https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/30568
>
> But your issue sounds like it may be something else? You could try this
> process:
>
> 1. Go to the add-in manager, uncheck the SMF add-in to deactivate it
> 2. Exit EXCEL (this hopefully will clear any pointers to the add-in)
> 3. Restart EXCEL
> 4. Go to the add-in manager, reactivate the SMF add-in using the "Browse"
> option
> 5. Exit EXCEL (to save the new install)
> 6. Restart EXCEL
> 7. Use this formula to make sure everything looks like you expect (it's
> loaded, folder location, version, etc):
>
> =RCHGetElementNumber("Version&quot;)
>
> On Fri, Dec 1, 2017 at 11:37 PM, Robbie Geary rgearyiii@
> ​...
> wrote:
>
>>
>> Every since I tried out another Excel add-in, Excel 2016 keeps forgetting
>> to load the SMF add-in. By that I mean in order to get SMF to work, I have
>> to disable it and then re-install it by browsing back to its original
>> location (Excel seems to keep a copy of it in my user files) every time I
>> start Excel.
>>
>> Has anyone else ever had this problem, and if so, how did you fix it?
>>
>>
>
>

--
Robbie Geary

Sat Dec 2, 2017 4:51 am (PST) . Posted by:

a.bereziuk

I have already fixed this issue. This was the case only with values with decimal point: % Chg, EPS TTM, Book Val. Excel formatting did not work for them. For "Average 3M Volume" it worked.
The problem was that I had comma as delimiter in my system (European Regional Setting). As I changed it to point it started working. At that changing to point only in Excel does not work. Changing to point in System and comma in Excel works.

Sat Dec 2, 2017 4:55 am (PST) . Posted by:

a.bereziuk

Is it possible to ask Yahoo to add new value to the array: "Dividend Frequency" (Monthly, Quarterly, etc.). ATR was also mentioned before.


Sat Dec 2, 2017 8:45 am (PST) . Posted by:

"Randy Harmelink" rharmelink

Unfortunately, I doubt any such suggestion to Yahoo would have any good
results...

On Sat, Dec 2, 2017 at 5:55 AM, a.bereziuk@
​...
wrote:

>
> Is it possible to ask Yahoo to add new value to the array: "Dividend
> Frequency" (Monthly, Quarterly, etc.). ATR was also mentioned before.
>
>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Tidak ada komentar:

Posting Komentar