Clear formula memory?
 

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

Clear formula memory?
 

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
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

Clear formula memory?
 

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
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