Messages In This Digest (4 Messages)

1a.: Re: Use of smf_addins cause excel to hang (i.e. not respond) From: alexander
1b.: Re: Use of smf_addins cause excel to hang (i.e. not respond) From: Randy Harmelink

2a.: Re: Excel 2010 From: NolanMadson

3a.: Re: MSN-10-Year-Summaries errors in elements 153-192 and 203-212 From: sacrifice_me

View All Topics | Create New Topic

Messages

1a.: Re: Use of smf_addins cause excel to hang (i.e. not respond)

Posted by: "alexander" alex.life2539@gmail.com life2539

Sat Jun 18, 2011 6:48 am (PDT)

Have you changing the calculations settings under File>Options to manual? The only catch is that you have to press f9 to get the smf information/calculation.

--- In smf_addin@yahoogroups.com, "E Spray" <espray@...> wrote:
>
> Any suggestions on resolving this problem is greatly appreciated.
>
> I've been using the smf_addins for over a year with no problems until today. I'm using IE8, Excel 2010, Windows 7 and the 2.1.2010.08.02 version of the addin. When opening a file or entering a formula by hand into an excel spreadsheet, the file begins to process the data query and immediately becomes hung (excel not responding).
>
> The source websites are all operative and I'm sure it's not an excel issue. I suspect the problem is with a setting within IE8 somehow changing - but not sure what it could be.
>
> I've verified the Internet Options / Settings / Miscellaneous / Access Data Sources Across Domains is set for "enabled" and restarted the computer. No success.
>
> Any thoughts or hints on possible solutions would be appreciated.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)
1b.: Re: Use of smf_addins cause excel to hang (i.e. not respond)

Posted by: "Randy Harmelink" rharmelink@gmail.com rharmelink

Sat Jun 18, 2011 12:10 pm (PDT)

Are you able to do EXCEL Web Queries to import data?

One thing you could try is to update the XML reference library in the VBA
project. When I originally wrote the add-in, I used the 5.0 version of the
library. However, many older versions of EXCEL didn't have that reference
library, so I chose to use the 3.0 version instead. If you upgrade it to the
most recent version of the library you have available, it may make a
difference?

It sounds like a recent Windows or EXCEL Update process may have changed
something, but I'd just be guessing...

On Fri, Jun 17, 2011 at 7:19 PM, E Spray <espray@optimum.net> wrote:

> Any suggestions on resolving this problem is greatly appreciated.
>
> I've been using the smf_addins for over a year with no problems until
> today. I'm using IE8, Excel 2010, Windows 7 and the 2.1.2010.08.02 version
> of the addin. When opening a file or entering a formula by hand into an
> excel spreadsheet, the file begins to process the data query and immediately
> becomes hung (excel not responding).
>
> The source websites are all operative and I'm sure it's not an excel issue.
> I suspect the problem is with a setting within IE8 somehow changing - but
> not sure what it could be.
>
> I've verified the Internet Options / Settings / Miscellaneous / Access Data
> Sources Across Domains is set for "enabled" and restarted the computer. No
> success.
>
> Any thoughts or hints on possible solutions would be appreciated.
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)

2a.: Re: Excel 2010

Posted by: "NolanMadson" nolanmadson@yahoo.com NolanMadson

Sat Jun 18, 2011 8:30 am (PDT)

> > Nolan
> >
> Is it possible or is the very good smf_addin Â·somewhat behind the curve.
> It goes w/ out saying the smf_addin Â·works extremely well on Excel 2007.
> Have you tried EXCEL 2007 and Excel 2010 o n the same PC.?? O
>

I don't have Excel 2007; I went right from Excel 2003 on my old machine to Excel 2010 on my new machine.

Thanks for the suggestion, tho.
Nolan

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (13)

3a.: Re: MSN-10-Year-Summaries errors in elements 153-192 and 203-212

Posted by: "sacrifice_me" sacrifice_me@yahoo.com sacrifice_me

Sat Jun 18, 2011 3:03 pm (PDT)

Yup, that was it :o)

Thank you very much!

--- In smf_addin@yahoogroups.com, Randy Harmelink <rharmelink@...> wrote:
>
> The template from the files area is working fine for me using ticker MMM.
>
> I suspect you just need the new smf-elements-1.txt file from the "Works in
> Progress" folder of the Files area of the group. I had to redefine a number
> of MSN elements back in January when MSN changed the structure of their web
> site.
>
> On Thu, Jun 16, 2011 at 1:18 PM, sacrifice_me <sacrifice_me@...>wrote:
>
> >
> > I just downloaded the SMF-Template-MSN-10-Year-Summaries.xls and figured
> > that elements 153 through 192 and 203 through 212 are coming up with
> > 'error'. Does anyone know more about this?
> >
> > Other than this, I don't have problems with the add-in and I'd like to
> > congratulate Randy on his work on this great tool.
> >
>

Back to top
Reply to sender | Reply to group | Reply via web post
Messages in this topic (3)