6 New Messages
Digest #2932
2a
Re: smfForceRecalculation - does it recalculate all open spreadsheet by "flangeneral" flangeneral
2b
Re: smfForceRecalculation - does it recalculate all open spreadsheet by "Randy Harmelink" rharmelink
Messages
Fri Jan 17, 2014 2:45 am (PST) . Posted by:
weekeewawa
hello randy,
bloomberg has changed the layout.
i was wondering how do i extract the data ''1-yr rtn'' from this page
http://www.bloomberg.com/quote/IBM:US
bloomberg has changed the layout.
i was wondering how do i extract the data ''1-
http://www.bloomber
Fri Jan 17, 2014 7:19 am (PST) . Posted by:
hamishthedenizen
Try
=RCHGetTableCell("http://www.bloomberg.com/quote/"&A1,1,"1-Yr Rtn:")
Where cell A1 contains the Bloomberg ticker IBM:US
=RCHGetTableCell(
Where cell A1 contains the Bloomberg ticker IBM:US
Fri Jan 17, 2014 6:22 am (PST) . Posted by:
"flangeneral" flangeneral
What is the difference between smfForceRecalculation and F9?
--- In smf_addin@yahoogroups.com, "Kermit W. Prather" <kermitp@...> wrote:
>
> I was setting up a button to assign the smfForceRecalculation macro so I can
> force a recalculation when I want to refresh my spreadsheet.
>
> I normally have more than one open spreadsheet with function using the
> SMF-Addin thus my question.
>
> Does the smfForceRecalculation refresh all open spreadsheets or just the
> active one?
>
> Thanks,
> Kermit
>
--- In smf_addin@yahoogrou
>
> I was setting up a button to assign the smfForceRecalculati
> force a recalculation when I want to refresh my spreadsheet.
>
> I normally have more than one open spreadsheet with function using the
> SMF-Addin thus my question.
>
> Does the smfForceRecalculati
> active one?
>
> Thanks,
> Kermit
>
Fri Jan 17, 2014 10:16 am (PST) . Posted by:
"Randy Harmelink" rharmelink
F9 will only recalculate the formulas.
However, most functions, like RCHGetElementNumber() or RCHGetTableCell()
extract data from a saved copy of a web page. So a simple recalculation
doesn't gain you much. It just extracts the same data from the same saved
copy of a web page.
smfForceRecalculation purges all of those saved web pages. That forces the
add-in to get a fresh copy of the web page from the Internet before
recalculating the formula. So then, the data extraction is from a new saved
copy of the web page.
On Fri, Jan 17, 2014 at 7:22 AM, flangeneral <jefff@rogers.com> wrote:
> What is the difference between smfForceRecalculation and F9?
>
However, most functions, like RCHGetElementNumber
extract data from a saved copy of a web page. So a simple recalculation
doesn't gain you much. It just extracts the same data from the same saved
copy of a web page.
smfForceRecalculati
add-in to get a fresh copy of the web page from the Internet before
recalculating the formula. So then, the data extraction is from a new saved
copy of the web page.
On Fri, Jan 17, 2014 at 7:22 AM, flangeneral <jefff@rogers.
> What is the difference between smfForceRecalculati
>
Fri Jan 17, 2014 6:26 pm (PST) . Posted by:
mikemcq802
I have some bad news about using SMF with Skydrive on Windows 8.1 and Excel2013.
My previous tests work and prove you can start an XLS that uses SMF from Skydrive.
BUT, after more thorough evaluation I do not think it is practical to do that.
My earlier tests used spreadsheets I created on my Win7/Excel2010 machine and then tested on my Win8.1/Excel2013 machine. I just opened and did an SMF lookup with them (worked fine) - I did not save them with Excel2013.
The problem is that once you save them with Excel2013 you will get the unresolved links errors. There is a work-around to prevent the unresolved links. You must use SAVE AS whenever saving a spreadsheet to Skydrive. You must do this each time you save to Skydrive, even if opening the xls from there. You cannot rely on the implicit "do you want to save" dialog when closing a worksheet either. You must always explicitly use SAVE AS.
This is a known Microsoft issue and their description of this is here. I played with this for a couple hours today and confirm it is as they say.
http://support.microsoft.com/kb/2769342/en-us
For me, this is too much of a nuisance to want to use Skydrive as my main storage for xls files.
This issue affects all spreadsheets with links to external spreadsheets. I have some of my own sheets linking to each other and it affects them the same way. SMF is not unique.
There is one other, um, interesting thing I uncovered about XLS files using SMF (i.e., w/external links). If an xls was last saved with Excel2013 you cannot copy/paste it from a local drive to Skydrive. To get it to Skydrive you must use SAVE AS. The interesting thing is that if you have a file last saved by Excel2010, you can copy/paste from a local drive to Skydrive and it works just fine (as long as you subsequently use SAVE AS if saving with Excel2013). For a while I thought I was hallucinating until I realized what was happening. I have some theories on this but suffice it to serve as a warning.
Hope this helps.
My previous tests work and prove you can start an XLS that uses SMF from Skydrive.
BUT, after more thorough evaluation I do not think it is practical to do that.
My earlier tests used spreadsheets I created on my Win7/Excel2010 machine and then tested on my Win8.1/Excel2013 machine. I just opened and did an SMF lookup with them (worked fine) - I did not save them with Excel2013.
The problem is that once you save them with Excel2013 you will get the unresolved links errors. There is a work-around to prevent the unresolved links. You must use SAVE AS whenever saving a spreadsheet to Skydrive. You must do this each time you save to Skydrive, even if opening the xls from there. You cannot rely on the implicit "do you want to save" dialog when closing a worksheet either. You must always explicitly use SAVE AS.
This is a known Microsoft issue and their description of this is here. I played with this for a couple hours today and confirm it is as they say.
http://support.
For me, this is too much of a nuisance to want to use Skydrive as my main storage for xls files.
This issue affects all spreadsheets with links to external spreadsheets. I have some of my own sheets linking to each other and it affects them the same way. SMF is not unique.
There is one other, um, interesting thing I uncovered about XLS files using SMF (i.e., w/external links). If an xls was last saved with Excel2013 you cannot copy/paste it from a local drive to Skydrive. To get it to Skydrive you must use SAVE AS. The interesting thing is that if you have a file last saved by Excel2010, you can copy/paste from a local drive to Skydrive and it works just fine (as long as you subsequently use SAVE AS if saving with Excel2013). For a while I thought I was hallucinating until I realized what was happening. I have some theories on this but suffice it to serve as a warning.
Hope this helps.
Fri Jan 17, 2014 8:01 pm (PST) . Posted by:
"ridgebacksexcel" ridgebacksexcel
Yes I am realizing the same thing.
I thought you had the answer but when I tried it I had the same problem.
The SMF Add in is in the Skydrive Folder in my Spreadsheet Folder.
I changed the Add In location in Excel by unchecking the add in box and browsing to the Skydrive folder as you suggested. So far so good.
I then updated the links when I opened Excel.
I then tried a test. If I "Save As" back into the Skydrive folder and open the file again, no problem. One more step than normal.
If I just save the file and reopen it, I get the link error message and have to edit the link again. A real pain.
Here is the location that Excel automatically changes it to:
'https://d.docs.live.net/95e7adb0712706ed/Documents/Spreadsheets/SMF Add-In/RCH_Stock_Market_Functions.xla'!
So for some reason it switches the location to the cloud server and not my Skydrive folder on the hard drive on my computer. Weird.
I will have to keep doing the "Save As" step until someone discovers a better way or Microsoft fixes the issue.
Thanks for the research in helping me better understand the problem.
I really want to use the Skydrive to sync my data on my desktop and laptop when I travel. I also like the security of my data as I cannot afford to ever lose it.
--- In smf_addin@yahoogroups.com, <mikemcq802@...> wrote:
>
> I have some bad news about using SMF with Skydrive on Windows 8.1 and Excel2013.
>
> My previous tests work and prove you can start an XLS that uses SMF from Skydrive.
>
> BUT, after more thorough evaluation I do not think it is practical to do that.
>
> My earlier tests used spreadsheets I created on my Win7/Excel2010 machine and then tested on my Win8.1/Excel2013 machine. I just opened and did an SMF lookup with them (worked fine) - I did not save them with Excel2013.
>
> The problem is that once you save them with Excel2013 you will get the unresolved links errors. There is a work-around to prevent the unresolved links. You must use SAVE AS whenever saving a spreadsheet to Skydrive. You must do this each time you save to Skydrive, even if opening the xls from there. You cannot rely on the implicit "do you want to save" dialog when closing a worksheet either. You must always explicitly use SAVE AS.
>
> This is a known Microsoft issue and their description of this is here. I played with this for a couple hours today and confirm it is as they say.
>
> http://support.microsoft.com/kb/2769342/en-us
>
> For me, this is too much of a nuisance to want to use Skydrive as my main storage for xls files.
>
> This issue affects all spreadsheets with links to external spreadsheets. I have some of my own sheets linking to each other and it affects them the same way. SMF is not unique.
>
> There is one other, um, interesting thing I uncovered about XLS files using SMF (i.e., w/external links). If an xls was last saved with Excel2013 you cannot copy/paste it from a local drive to Skydrive. To get it to Skydrive you must use SAVE AS. The interesting thing is that if you have a file last saved by Excel2010, you can copy/paste from a local drive to Skydrive and it works just fine (as long as you subsequently use SAVE AS if saving with Excel2013). For a while I thought I was hallucinating until I realized what was happening. I have some theories on this but suffice it to serve as a warning.
>
> Hope this helps.
>
I thought you had the answer but when I tried it I had the same problem.
The SMF Add in is in the Skydrive Folder in my Spreadsheet Folder.
I changed the Add In location in Excel by unchecking the add in box and browsing to the Skydrive folder as you suggested. So far so good.
I then updated the links when I opened Excel.
I then tried a test. If I "Save As" back into the Skydrive folder and open the file again, no problem. One more step than normal.
If I just save the file and reopen it, I get the link error message and have to edit the link again. A real pain.
Here is the location that Excel automatically changes it to:
'https://d.docs.
So for some reason it switches the location to the cloud server and not my Skydrive folder on the hard drive on my computer. Weird.
I will have to keep doing the "Save As" step until someone discovers a better way or Microsoft fixes the issue.
Thanks for the research in helping me better understand the problem.
I really want to use the Skydrive to sync my data on my desktop and laptop when I travel. I also like the security of my data as I cannot afford to ever lose it.
--- In smf_addin@yahoogrou
>
> I have some bad news about using SMF with Skydrive on Windows 8.1 and Excel2013.
>
> My previous tests work and prove you can start an XLS that uses SMF from Skydrive.
>
> BUT, after more thorough evaluation I do not think it is practical to do that.
>
> My earlier tests used spreadsheets I created on my Win7/Excel2010 machine and then tested on my Win8.1/Excel2013 machine. I just opened and did an SMF lookup with them (worked fine) - I did not save them with Excel2013.
>
> The problem is that once you save them with Excel2013 you will get the unresolved links errors. There is a work-around to prevent the unresolved links. You must use SAVE AS whenever saving a spreadsheet to Skydrive. You must do this each time you save to Skydrive, even if opening the xls from there. You cannot rely on the implicit "do you want to save" dialog when closing a worksheet either. You must always explicitly use SAVE AS.
>
> This is a known Microsoft issue and their description of this is here. I played with this for a couple hours today and confirm it is as they say.
>
> http://support.
>
> For me, this is too much of a nuisance to want to use Skydrive as my main storage for xls files.
>
> This issue affects all spreadsheets with links to external spreadsheets. I have some of my own sheets linking to each other and it affects them the same way. SMF is not unique.
>
> There is one other, um, interesting thing I uncovered about XLS files using SMF (i.e., w/external links). If an xls was last saved with Excel2013 you cannot copy/paste it from a local drive to Skydrive. To get it to Skydrive you must use SAVE AS. The interesting thing is that if you have a file last saved by Excel2010, you can copy/paste from a local drive to Skydrive and it works just fine (as long as you subsequently use SAVE AS if saving with Excel2013). For a while I thought I was hallucinating until I realized what was happening. I have some theories on this but suffice it to serve as a warning.
>
> Hope this helps.
>
Tidak ada komentar:
Posting Komentar