Rabu, 17 Juli 2019

[smf_addin] Digest Number 4578

5 Messages

Digest #4578

Messages

Tue Jul 16, 2019 7:09 am (PDT) . Posted by:

a.bereziuk

Hello,


I have several xlsm-files with smf-functions. Every time I open a file all functions start and it takes time. Is it possible to prevent smf functions from starting in a particular file if I don't want to recalculate there? Excel functionality "automatic/manual (F9) calculations" is valid for all files. This setting is global.

Tue Jul 16, 2019 8:35 am (PDT) . Posted by:

"Randy Harmelink" rharmelink

For some of my workbooks, I use the smfUpdateDownloadTable so that the
saved workbook has a table of values, instead of a table of formulas. Then
I can recalculate things as needed.

For some other workbooks, I use a calculation switch. Something like:

IF($A$1=0,"--",smf....())

But then you have to remember to set cell A1 to 0 before saving the
workbook, and it won't have any values when you open it.

Otherwise, you'd need to toggle the manual recalculation setting of EXCEL.

On Tue, Jul 16, 2019 at 7:57 AM a.bereziuk@.. wrote:

> I have several xlsm-files with smf-functions. Every time I open a file all
> functions start and it takes time. Is it possible to prevent smf functions
> from starting in a particular file if I don't want to recalculate there?
> Excel functionality "automatic/manual (F9) calculations" is valid for all
> files. This setting is global.
>
>

Tue Jul 16, 2019 7:17 am (PDT) . Posted by:

a.bereziuk

thanks, worth considering if not so lazy ))

Tue Jul 16, 2019 3:35 pm (PDT) . Posted by:

"Yahoo!" lewglenn

It's working now. Thanks.
On Sunday, July 14, 2019, 04:49:33 PM PDT, Randy Harmelink rharmelink@gmail.com [smf_addin] <smf_addin@yahoogroups.com> wrote:

 

Did you exit EXCEL before updating the XLA file? Add-ins are only loaded when EXCEL starts up.
Otherwise, did you update the XLA in the correct folder?
On Sun, Jul 14, 2019 at 3:26 PM lewglenn@... wrote:

I just went to the website and downloaded the latest add-in (2.1.2018.01.24). After I installed it and ran my code to check on the version I got:
| Stock Market Functions add-in, Version 2.1.2017.11.08 (C:\Program Files\SMF Add-in; Windows (32-bit) NT 6.02; 12.0; ; ; 1)

Any idea as to what I did wrong? |

#yiv3700502137 #yiv3700502137 -- #yiv3700502137ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv3700502137 #yiv3700502137ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv3700502137 #yiv3700502137ygrp-mkp #yiv3700502137hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv3700502137 #yiv3700502137ygrp-mkp #yiv3700502137ads {margin-bottom:10px;}#yiv3700502137 #yiv3700502137ygrp-mkp .yiv3700502137ad {padding:0 0;}#yiv3700502137 #yiv3700502137ygrp-mkp .yiv3700502137ad p {margin:0;}#yiv3700502137 #yiv3700502137ygrp-mkp .yiv3700502137ad a {color:#0000ff;text-decoration:none;}#yiv3700502137 #yiv3700502137ygrp-sponsor #yiv3700502137ygrp-lc {font-family:Arial;}#yiv3700502137 #yiv3700502137ygrp-sponsor #yiv3700502137ygrp-lc #yiv3700502137hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv3700502137 #yiv3700502137ygrp-sponsor #yiv3700502137ygrp-lc .yiv3700502137ad {margin-bottom:10px;padding:0 0;}#yiv3700502137 #yiv3700502137actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv3700502137 #yiv3700502137activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv3700502137 #yiv3700502137activity span {font-weight:700;}#yiv3700502137 #yiv3700502137activity span:first-child {text-transform:uppercase;}#yiv3700502137 #yiv3700502137activity span a {color:#5085b6;text-decoration:none;}#yiv3700502137 #yiv3700502137activity span span {color:#ff7900;}#yiv3700502137 #yiv3700502137activity span .yiv3700502137underline {text-decoration:underline;}#yiv3700502137 .yiv3700502137attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv3700502137 .yiv3700502137attach div a {text-decoration:none;}#yiv3700502137 .yiv3700502137attach img {border:none;padding-right:5px;}#yiv3700502137 .yiv3700502137attach label {display:block;margin-bottom:5px;}#yiv3700502137 .yiv3700502137attach label a {text-decoration:none;}#yiv3700502137 blockquote {margin:0 0 0 4px;}#yiv3700502137 .yiv3700502137bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv3700502137 .yiv3700502137bold a {text-decoration:none;}#yiv3700502137 dd.yiv3700502137last p a {font-family:Verdana;font-weight:700;}#yiv3700502137 dd.yiv3700502137last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv3700502137 dd.yiv3700502137last p span.yiv3700502137yshortcuts {margin-right:0;}#yiv3700502137 div.yiv3700502137attach-table div div a {text-decoration:none;}#yiv3700502137 div.yiv3700502137attach-table {width:400px;}#yiv3700502137 div.yiv3700502137file-title a, #yiv3700502137 div.yiv3700502137file-title a:active, #yiv3700502137 div.yiv3700502137file-title a:hover, #yiv3700502137 div.yiv3700502137file-title a:visited {text-decoration:none;}#yiv3700502137 div.yiv3700502137photo-title a, #yiv3700502137 div.yiv3700502137photo-title a:active, #yiv3700502137 div.yiv3700502137photo-title a:hover, #yiv3700502137 div.yiv3700502137photo-title a:visited {text-decoration:none;}#yiv3700502137 div#yiv3700502137ygrp-mlmsg #yiv3700502137ygrp-msg p a span.yiv3700502137yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv3700502137 .yiv3700502137green {color:#628c2a;}#yiv3700502137 .yiv3700502137MsoNormal {margin:0 0 0 0;}#yiv3700502137 o {font-size:0;}#yiv3700502137 #yiv3700502137photos div {float:left;width:72px;}#yiv3700502137 #yiv3700502137photos div div {border:1px solid #666666;min-height:62px;overflow:hidden;width:62px;}#yiv3700502137 #yiv3700502137photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv3700502137 #yiv3700502137reco-category {font-size:77%;}#yiv3700502137 #yiv3700502137reco-desc {font-size:77%;}#yiv3700502137 .yiv3700502137replbq {margin:4px;}#yiv3700502137 #yiv3700502137ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv3700502137 #yiv3700502137ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv3700502137 #yiv3700502137ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv3700502137 #yiv3700502137ygrp-mlmsg select, #yiv3700502137 input, #yiv3700502137 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv3700502137 #yiv3700502137ygrp-mlmsg pre, #yiv3700502137 code {font:115% monospace;}#yiv3700502137 #yiv3700502137ygrp-mlmsg * {line-height:1.22em;}#yiv3700502137 #yiv3700502137ygrp-mlmsg #yiv3700502137logo {padding-bottom:10px;}#yiv3700502137 #yiv3700502137ygrp-msg p a {font-family:Verdana;}#yiv3700502137 #yiv3700502137ygrp-msg p#yiv3700502137attach-count span {color:#1E66AE;font-weight:700;}#yiv3700502137 #yiv3700502137ygrp-reco #yiv3700502137reco-head {color:#ff7900;font-weight:700;}#yiv3700502137 #yiv3700502137ygrp-reco {margin-bottom:20px;padding:0px;}#yiv3700502137 #yiv3700502137ygrp-sponsor #yiv3700502137ov li a {font-size:130%;text-decoration:none;}#yiv3700502137 #yiv3700502137ygrp-sponsor #yiv3700502137ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv3700502137 #yiv3700502137ygrp-sponsor #yiv3700502137ov ul {margin:0;padding:0 0 0 8px;}#yiv3700502137 #yiv3700502137ygrp-text {font-family:Georgia;}#yiv3700502137 #yiv3700502137ygrp-text p {margin:0 0 1em 0;}#yiv3700502137 #yiv3700502137ygrp-text tt {font-size:120%;}#yiv3700502137 #yiv3700502137ygrp-vital ul li:last-child {border-right:none !important;}#yiv3700502137
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Diposting oleh EXCEL FEED LEARNING di 05.56

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)