Clear formula memory?

[Matt Williamson]

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]

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/excel/HA010346091033.aspx

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

 

[Gord Dibben]

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

 

[Matt Williamson]

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/excel/HA010346091033.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

 

[Matt Williamson]

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

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