I'm having a very odd issue that I can't seem to figure out what is
going on. I have a spreadsheet that contains formulas that reference an
add-in that gets stock info. The add-in only recognizes tickers that are
in uppercase in the latest version. In earlier versions it didn't seem
to matter. I just recently upgraded to the latest version of this add-in
and none of the formulas where the tickers are in mixed case function
properly. The problem is, I can't change them to upper case. If I do, it
automatically reverts back to mixed case. I'm thinking there is some
sort of memory cache for formulas that it's reading from but I've turned
off every autocomplete feature that I can find. The odd thing is if I
close that workbook, open a new one and manually type the formula with
the ticker in upper case, then re-open the original workbook, every
instance where it was in mixed case changes to uppercase now. Is there
any way to control this "feature"? I've tried a Find/Replace but that
doesn't work. I'm pretty good with VBA if anyone can recommend a way to
fix it with code.

TIA

Matt

Hi,

What are the formulas that are pulling the stock quotes in? There may be
some way to use Excel's UPPER function in the formulas.

Microsoft has a free download called MSNStockQuote, why don't you use that?

How to use it and where to down load it are all discussed here:

http://office.microsoft.com/en-us/ex...346091033.aspx

It also tells you the advantage of using it rather than a Web query.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Matt Williamson" wrote:

> I'm having a very odd issue that I can't seem to figure out what is
> going on. I have a spreadsheet that contains formulas that reference an
> add-in that gets stock info. The add-in only recognizes tickers that are
> in uppercase in the latest version. In earlier versions it didn't seem
> to matter. I just recently upgraded to the latest version of this add-in
> and none of the formulas where the tickers are in mixed case function
> properly. The problem is, I can't change them to upper case. If I do, it
> automatically reverts back to mixed case. I'm thinking there is some
> sort of memory cache for formulas that it's reading from but I've turned
> off every autocomplete feature that I can find. The odd thing is if I
> close that workbook, open a new one and manually type the formula with
> the ticker in upper case, then re-open the original workbook, every
> instance where it was in mixed case changes to uppercase now. Is there
> any way to control this "feature"? I've tried a Find/Replace but that
> doesn't work. I'm pretty good with VBA if anyone can recommend a way to
> fix it with code.
>
> TIA
>
> Matt
>

Autocorrect may be kicking in and correcting when first 2 characters are
entered in uppercase.

Uncheck that option in the Autocorrect options.


Gord Dibben MS Excel MVP

On Tue, 02 Jun 2009 11:45:30 -0400, Matt Williamson
<(E-Mail Removed)> wrote:

>I'm having a very odd issue that I can't seem to figure out what is
>going on. I have a spreadsheet that contains formulas that reference an
>add-in that gets stock info. The add-in only recognizes tickers that are
>in uppercase in the latest version. In earlier versions it didn't seem
>to matter. I just recently upgraded to the latest version of this add-in
> and none of the formulas where the tickers are in mixed case function
>properly. The problem is, I can't change them to upper case. If I do, it
>automatically reverts back to mixed case. I'm thinking there is some
>sort of memory cache for formulas that it's reading from but I've turned
>off every autocomplete feature that I can find. The odd thing is if I
>close that workbook, open a new one and manually type the formula with
>the ticker in upper case, then re-open the original workbook, every
>instance where it was in mixed case changes to uppercase now. Is there
>any way to control this "feature"? I've tried a Find/Replace but that
>doesn't work. I'm pretty good with VBA if anyone can recommend a way to
>fix it with code.
>
>TIA
>
>Matt

Shane Devenshire wrote:
> Hi,
>
> What are the formulas that are pulling the stock quotes in? There may be
> some way to use Excel's UPPER function in the formulas.
>
> Microsoft has a free download called MSNStockQuote, why don't you use that?
>
> How to use it and where to down load it are all discussed here:
>
> http://office.microsoft.com/en-us/ex...346091033.aspx
>
> It also tells you the advantage of using it rather than a Web query.
>

I'm the Admin at an IA/BD and my users are experiencing this issue. I
would do something along those lines myself but they have an established
workbook already that would take a while to re-design. The software in
question goes much deeper than just stock quotes. Thanks for the info
though, I'll check it out.

Matt

Gord Dibben wrote:
> Autocorrect may be kicking in and correcting when first 2 characters are
> entered in uppercase.
>
> Uncheck that option in the Autocorrect options.
>
>
> Gord Dibben MS Excel MVP
>
> On Tue, 02 Jun 2009 11:45:30 -0400, Matt Williamson
> <(E-Mail Removed)> wrote:
>
>> I'm having a very odd issue that I can't seem to figure out what is
>> going on. I have a spreadsheet that contains formulas that reference an
>> add-in that gets stock info. The add-in only recognizes tickers that are
>> in uppercase in the latest version. In earlier versions it didn't seem
>> to matter. I just recently upgraded to the latest version of this add-in
>> and none of the formulas where the tickers are in mixed case function
>> properly. The problem is, I can't change them to upper case. If I do, it
>> automatically reverts back to mixed case. I'm thinking there is some
>> sort of memory cache for formulas that it's reading from but I've turned
>> off every autocomplete feature that I can find. The odd thing is if I
>> close that workbook, open a new one and manually type the formula with
>> the ticker in upper case, then re-open the original workbook, every
>> instance where it was in mixed case changes to uppercase now. Is there
>> any way to control this "feature"? I've tried a Find/Replace but that
>> doesn't work. I'm pretty good with VBA if anyone can recommend a way to
>> fix it with code.
>>
>> TIA
>>
>> Matt
>

I turned off every autocorrect option. It still happens. The only way
I've found to stop it is to delete EVERY instance of that formula in the
spreadsheet, save/close and re-open then type it fresh in uppercase. Not
fun with about 600 formulas across multiple sheets