Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to clear clipboard memory? | Excel Discussion (Misc queries) | |||
Clear formula memory? | Excel Discussion (Misc queries) | |||
Clear clipboard memory | Excel Programming | |||
Memory/Cache Clear: | Excel Programming | |||
Do you wish to clear clipboard memory? | Excel Programming |