[smf_addin] Digest Number 3857[6 Attachments]

EXCEL Stock Market Functions Add-in Group

3 Messages

Digest #3857

1

#NAME! Error not fixed with Find and Replace by coreyjhansen

2.1

Re: Microsoft Excel security message by coreyjhansen

2.2

Re: Microsoft Excel security message by "Randy Harmelink" rharmelink

Messages

1

#NAME! Error not fixed with Find and Replace

Thu Dec 1, 2016 10:42 am (PST) . Posted by:

coreyjhansen

Excel: 2013
Windows 7 64-bit
SMF template: Yahoo Key Statistics


I have followed the Youtube video directions for using Find and Replace to remove hard-coded links with no success. The hard-coded pathway is removed from the link and the formula in each cell displays exactly as shown in the video. After clicking "replace All" the cell values all change to 0 but then revert to #NAME! as soon as the Find and Replace completes.


Please see the attached screenshots. I appreciate your time ad consideration in helping me solve this problem.


Corey

Attachment(s) from

6 of 6 Photo(s)

SMF folder contents.PNG

Corey SMF Add-in location.PNG

Excel Model Comp Formula.PNG

SMF location.PNG

Cell C8 formula.PNG

NAME Error asfter Find and Replace exercise.PNG

Reply to sender . Reply to group . Reply via Web Post . All Messages (1) . Top ^

2.1

Re: Microsoft Excel security message

Thu Dec 1, 2016 10:59 am (PST) . Posted by:

coreyjhansen

Thank you for your time and consideration in replying.

My apologies. It appears my company has migrated to Excel 2016. Does this change your corrective action?

Reply to sender . Reply to group . Reply via Web Post . All Messages (39) . Top ^

2.2

Re: Microsoft Excel security message

Thu Dec 1, 2016 11:50 am (PST) . Posted by:

"Randy Harmelink" rharmelink

It's Microsoft's suggestion, not mine. I'm not sure if that is your problem
or not. I only have EXCEL 2007, so can't answer what happens with other
versions of EXCEL.

I know before the work-around from Microsoft was released, some people had
to uncheck and recheck the add-in every time they started up EXCEL, or it
wasn't really loaded.

On Thu, Dec 1, 2016 at 11:59 AM, coreyjhansen@
​...wrote:

>
> My apologies. It appears my company has migrated to Excel 2016. Does this
> change your corrective action?
>
>

Reply to sender . Reply to group . Reply via Web Post . All Messages (39) . Top ^

For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF

Visit Your Group

• New Members 12

• Privacy • Unsubscribe • Terms of Use