8 Messages
Digest #4129
Messages
Fri Aug 25, 2017 9:24 am (PDT) . Posted by:
ridgebacksexcel
Randy,
Apparently Google Drive behaves differently than OneDrive.
I have been running some tests with a simple spreadsheet that just pulls a quote from a stock to test various ways to save the file and locations.
I normally keep my spreadsheets in the OneDrive/Spreadsheets folder.
The SMF program is under C:/Program Files/SMF Add-in/RCH_Stock_Market_Functions.xla
What I know so far:
The SMF Add-in will only run locally on my computer, not anywhere in the OneDrive folder on my computer.
I tried changing the location to C:/SMF Add-In as you have it but it crashed Excel and then would not run after I managed to get Excel up. So I went back to my original location and it seems to work from there.
I tried running the Test spreadsheet from OneDrive with no subfolder. I saves there ok. I open it up again and it shows a button to enable content. Automatic links are disabled. I enable it and I get the same error, unable to open https://d.docs.live.net/Program https://d.docs.live.net/Program Files/SMF Add-in
For some reason, OneDrive when it saves the file changes the Add-in Location it looks for from
C:/Program Files/SMF Add-in
to https://d.docs.live.net/Program https://d.docs.live.net/Program Files/SMF Add-in/RCH_Stock_Market_Functions.xla
The only fix is when you open the file to do this:
It asks to update links. Select Don't Update.
Then select Data, Edit Links.
Then select Change Source.
Then I have to browse to my Program Files folder, then SMF-Add In, then select the RCH_Stock_Market_Functions.xla file
I select ok. Then close the Edit links box and the add-in will run again. Everything is normal until the file saves automatically and I close it.
Once I reopen it I have to start the process all over again.
The only other fix is to Save and run my Workbook locally and NOT under the OneDrive Folder. This defeats the purpose of OneDrive and does not saves files to the cloud. I haven't decided yet which way I want to proceed in the future as both ways have their issues.
So unless you have another solution you can think of, I will keep playing with it and decide which is the lessor of two evils.
Maybe you could test it out under OneDrive if you have access to it since you now are running the new build. If you see an AutoSave toggle button in the upper left corner you are running the right spreadsheet build. Also it will be greyed out if the file is stored locally and only activate if stored in the OneDrive folder, thus beginning the problem.
Hope this helps zero in on the problem.
Apparently Google Drive behaves differently than OneDrive.
I have been running some tests with a simple spreadsheet that just pulls a quote from a stock to test various ways to save the file and locations.
I normally keep my spreadsheets in the OneDrive/Spreadsheets folder.
The SMF program is under C:/Program Files/SMF Add-in/RCH_Stock_Market_Functions.xla
What I know so far:
The SMF Add-in will only run locally on my computer, not anywhere in the OneDrive folder on my computer.
I tried changing the location to C:/SMF Add-In as you have it but it crashed Excel and then would not run after I managed to get Excel up. So I went back to my original location and it seems to work from there.
I tried running the Test spreadsheet from OneDrive with no subfolder. I saves there ok. I open it up again and it shows a button to enable content. Automatic links are disabled. I enable it and I get the same error, unable to open https://d.docs.live.net/Program https://d.docs.live.net/Program Files/SMF Add-in
For some reason, OneDrive when it saves the file changes the Add-in Location it looks for from
C:/Program Files/SMF Add-in
to https://d.docs.live.net/Program https://d.docs.live.net/Program Files/SMF Add-in/RCH_Stock_
The only fix is when you open the file to do this:
It asks to update links. Select Don't Update.
Then select Data, Edit Links.
Then select Change Source.
Then I have to browse to my Program Files folder, then SMF-Add In, then select the RCH_Stock_Market_
I select ok. Then close the Edit links box and the add-in will run again. Everything is normal until the file saves automatically and I close it.
Once I reopen it I have to start the process all over again.
The only other fix is to Save and run my Workbook locally and NOT under the OneDrive Folder. This defeats the purpose of OneDrive and does not saves files to the cloud. I haven't decided yet which way I want to proceed in the future as both ways have their issues.
So unless you have another solution you can think of, I will keep playing with it and decide which is the lessor of two evils.
Maybe you could test it out under OneDrive if you have access to it since you now are running the new build. If you see an AutoSave toggle button in the upper left corner you are running the right spreadsheet build. Also it will be greyed out if the file is stored locally and only activate if stored in the OneDrive folder, thus beginning the problem.
Hope this helps zero in on the problem.
Fri Aug 25, 2017 10:02 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The quicker way to do the process might be to just run the smfFixLinks
macro after you get the notice of unresolved links. I have the macro
assigned to a button on my Quick Access Toolbar. It's always available on
the context menu (i.e. right mouse click).
On Fri, Aug 25, 2017 at 9:24 AM, tmallen2@
...
wrote:
> Apparently Google Drive behaves differently than OneDrive.
>
> I have been running some tests with a simple spreadsheet that just pulls a
> quote from a stock to test various ways to save the file and locations.
>
> I normally keep my spreadsheets in the OneDrive/Spreadsheets folder.
>
> The SMF program is under C:/Program Files/SMF Add-in/RCH_Stock_Market_
> Functions.xla
>
> What I know so far:
>
> The SMF Add-in will only run locally on my computer, not anywhere in the
> OneDrive folder on my computer.
>
> I tried changing the location to C:/SMF Add-In as you have it but it
> crashed Excel and then would not run after I managed to get Excel up. So I
> went back to my original location and it seems to work from there.
>
> I tried running the Test spreadsheet from OneDrive with no subfolder. I
> saves there ok. I open it up again and it shows a button to enable content.
> Automatic links are disabled. I enable it and I get the same error, unable
> to open https://d.docs.live.net/Program Files/SMF Add-in
>
> For some reason, OneDrive when it saves the file changes the Add-in
> Location it looks for from
>
> C:/Program Files/SMF Add-in
>
> to *https://d.docs.live.net/Program* <https://d.docs.live.net/Program> Files/SMF
> Add-in/RCH_Stock_Market_Functions.xla
>
> The only fix is when you open the file to do this:
>
> It asks to update links. Select Don't Update.
>
> Then select Data, Edit Links.
>
> Then select Change Source.
>
> Then I have to browse to my Program Files folder, then SMF-Add In, then
> select the RCH_Stock_Market_Functions.xla file
>
> I select ok. Then close the Edit links box and the add-in will run again.
> Everything is normal until the file saves automatically and I close it.
>
> Once I reopen it I have to start the process all over again.
>
> The only other fix is to Save and run my Workbook locally and NOT under
> the OneDrive Folder. This defeats the purpose of OneDrive and does not
> saves files to the cloud. I haven't decided yet which way I want to proceed
> in the future as both ways have their issues.
>
> So unless you have another solution you can think of, I will keep playing
> with it and decide which is the lessor of two evils.
>
> Maybe you could test it out under OneDrive if you have access to it since
> you now are running the new build. If you see an AutoSave toggle button in
> the upper left corner you are running the right spreadsheet build. Also it
> will be greyed out if the file is stored locally and only activate if
> stored in the OneDrive folder, thus beginning the problem.
>
> Hope this helps zero in on the problem.
>
>
>
macro after you get the notice of unresolved links. I have the macro
assigned to a button on my Quick Access Toolbar. It's always available on
the context menu (i.e. right mouse click).
On Fri, Aug 25, 2017 at 9:24 AM, tmallen2@
...
wrote:
> Apparently Google Drive behaves differently than OneDrive.
>
> I have been running some tests with a simple spreadsheet that just pulls a
> quote from a stock to test various ways to save the file and locations.
>
> I normally keep my spreadsheets in the OneDrive/Spreadsheets folder.
>
> The SMF program is under C:/Program Files/SMF Add-in/RCH_Stock_Market_
> Functions.xla
>
> What I know so far:
>
> The SMF Add-in will only run locally on my computer, not anywhere in the
> OneDrive folder on my computer.
>
> I tried changing the location to C:/SMF Add-In as you have it but it
> crashed Excel and then would not run after I managed to get Excel up. So I
> went back to my original location and it seems to work from there.
>
> I tried running the Test spreadsheet from OneDrive with no subfolder. I
> saves there ok. I open it up again and it shows a button to enable content.
> Automatic links are disabled. I enable it and I get the same error, unable
> to open https://d.docs.live.net/Program Files/SMF Add-in
>
> For some reason, OneDrive when it saves the file changes the Add-in
> Location it looks for from
>
> C:/Program Files/SMF Add-in
>
> to *https://d.docs.live.net/Program* <https://d.docs.live.net/Program> Files/SMF
> Add-in/RCH_Stock_
>
> The only fix is when you open the file to do this:
>
> It asks to update links. Select Don't Update.
>
> Then select Data, Edit Links.
>
> Then select Change Source.
>
> Then I have to browse to my Program Files folder, then SMF-Add In, then
> select the RCH_Stock_Market_
>
> I select ok. Then close the Edit links box and the add-in will run again.
> Everything is normal until the file saves automatically and I close it.
>
> Once I reopen it I have to start the process all over again.
>
> The only other fix is to Save and run my Workbook locally and NOT under
> the OneDrive Folder. This defeats the purpose of OneDrive and does not
> saves files to the cloud. I haven't decided yet which way I want to proceed
> in the future as both ways have their issues.
>
> So unless you have another solution you can think of, I will keep playing
> with it and decide which is the lessor of two evils.
>
> Maybe you could test it out under OneDrive if you have access to it since
> you now are running the new build. If you see an AutoSave toggle button in
> the upper left corner you are running the right spreadsheet build. Also it
> will be greyed out if the file is stored locally and only activate if
> stored in the OneDrive folder, thus beginning the problem.
>
> Hope this helps zero in on the problem.
>
>
>
Fri Aug 25, 2017 10:25 am (PDT) . Posted by:
ridgebacksexcel
Randy, excuse my ignorance, but how exactly do you use the SMFfixlinks Macro?
I see it under right click, SMF, fix links.
When I select it nothing happens.
What exactly do I have to do to enable it and run the fix I use?
I see it under right click, SMF, fix links.
When I select it nothing happens.
What exactly do I have to do to enable it and run the fix I use?
Fri Aug 25, 2017 10:51 am (PDT) . Posted by:
"Randy Harmelink" rharmelink
The macro should do a "change all" to remove all of the location prefixes
to the add-in functions, replacing all of these occurrences in formulas:
"'*\RCH_Stock_Market_Functions.xla'!"
On Fri, Aug 25, 2017 at 10:25 AM, tmallen2@
...
wrote:
> Randy, excuse my ignorance, but how exactly do you use the SMFfixlinks
> Macro?
>
> I see it under right click, SMF, fix links.
>
> When I select it nothing happens.
>
> What exactly do I have to do to enable it and run the fix I use?
>
to the add-in functions, replacing all of these occurrences in formulas:
"'*
On Fri, Aug 25, 2017 at 10:25 AM, tmallen2@
...
wrote:
> Randy, excuse my ignorance, but how exactly do you use the SMFfixlinks
> Macro?
>
> I see it under right click, SMF, fix links.
>
> When I select it nothing happens.
>
> What exactly do I have to do to enable it and run the fix I use?
>
Fri Aug 25, 2017 1:05 pm (PDT) . Posted by:
mjblauer
Randy try clicking this LINK - under photos files LINKS http://finance.groups.yahoo.com/group/smf_addin/message/7625 http://finance.groups.yahoo.com/group/smf_addin/message/7625
Fri Aug 25, 2017 1:24 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Ah...now I see what you mean. It appears Yahoo is no longer redirecting old
URLs to the new ones.
I'll have to do some updates, as this:
http://finance.groups.yahoo.com/group/smf_addin/message/7625
...should now be:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/7625
On Fri, Aug 25, 2017 at 1:05 PM, mblauer@
...
wrote:
>
> Randy try clicking this LINK - under photos files LINKS
> http://finance.groups.yahoo.com/group/smf_addin/message/7625
>
>
URLs to the new ones.
I'll have to do some updates, as this:
http://finance.groups.yahoo.com/group/smf_addin/message/7625
...should now be:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/7625
On Fri, Aug 25, 2017 at 1:05 PM, mblauer@
...
wrote:
>
> Randy try clicking this LINK - under photos files LINKS
> http://finance.groups.yahoo.com/group/smf_addin/message/7625
>
>
Fri Aug 25, 2017 1:25 pm (PDT) . Posted by:
"Randy Harmelink" rharmelink
Oops... should be:
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/7625
On Fri, Aug 25, 2017 at 1:24 PM, Randy Harmelink <rharmelink@gmail.com>
wrote:
> Ah...now I see what you mean. It appears Yahoo is no longer redirecting
> old URLs to the new ones.
>
> I'll have to do some updates, as this:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/7625
>
> ...should now be:
>
> https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/7625
>
>
> On Fri, Aug 25, 2017 at 1:05 PM, mblauer@
> ...
> wrote:
>
>>
>> Randy try clicking this LINK - under photos files LINKS
>> http://finance.groups.yahoo.com/group/smf_addin/message/7625
>>
>>
>
https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/7625
On Fri, Aug 25, 2017 at 1:24 PM, Randy Harmelink <rharmelink@gmail.com>
wrote:
> Ah...now I see what you mean. It appears Yahoo is no longer redirecting
> old URLs to the new ones.
>
> I'll have to do some updates, as this:
>
> http://finance.groups.yahoo.com/group/smf_addin/message/7625
>
> ...should now be:
>
> https://groups.yahoo.com/neo/groups/smf_addin/conversations/messages/7625
>
>
> On Fri, Aug 25, 2017 at 1:05 PM, mblauer@
> ...
> wrote:
>
>>
>> Randy try clicking this LINK - under photos files LINKS
>> http://finance.groups.yahoo.com/group/smf_addin/message/7625
>>
>>
>
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
Tidak ada komentar:
Posting Komentar