[smf_addin] Digest Number 4481

EXCEL Stock Market Functions Add-in Group

2 Messages

Digest #4481

1a

Re: smf functions being replaced by #N/A by kitiany

1b

Re: smf functions being replaced by #N/A by kitiany

Messages

1a

Re: smf functions being replaced by #N/A

Mon Feb 4, 2019 1:22 pm (PST) . Posted by:

kitiany

It seems to affect mostly smfGetYahooPortfolioView("AAPL","15"). I get the error message "File error. Data may have been lost." I can retype the formula, save the file, reopen it, and it gives me that message and all of the formulas are replaced by #N/A.
It is too much of a coincidence that this started about same time I switched to Windows 10.

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

1b

Re: smf functions being replaced by #N/A

Mon Feb 4, 2019 2:45 pm (PST) . Posted by:

kitiany

It isn't the functions or formulas. I create a new worksheet to replicate my old worksheet and that it somehow became corrupted. It must be some new security thing that my company implemented along with Windows 10. I'll recreate the worksheet from old ones see how long the recreated sheet lasts without error.

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

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

Visit Your Group

• Privacy • Unsubscribe • Terms of Use