| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
External data import with a formula, fiormula is not evaluated
I import data from a database into Excel. One of the fields contains a
formula. However, the Formula is not evaluated after the import. All the rest works fine. Only if I enter the cell via F2 and then get out again the formual is evaluated. Is there a workaround, without using VBA? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
External data import with a formula, fiormula is not evaluated
First suggestion:
ToolsOptionsCalculationAutomatic, but I guess you will have tried that. Otherwise can you post the formula here. -- Allllen "Sierrraxray" wrote: I import data from a database into Excel. One of the fields contains a formula. However, the Formula is not evaluated after the import. All the rest works fine. Only if I enter the cell via F2 and then get out again the formual is evaluated. Is there a workaround, without using VBA? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
External data import with a formula, fiormula is not evaluated
The Formula is very simple: =RC(-1)&RC(1)
"Allllen" wrote: First suggestion: ToolsOptionsCalculationAutomatic, but I guess you will have tried that. Otherwise can you post the formula here. -- Allllen "Sierrraxray" wrote: I import data from a database into Excel. One of the fields contains a formula. However, the Formula is not evaluated after the import. All the rest works fine. Only if I enter the cell via F2 and then get out again the formual is evaluated. Is there a workaround, without using VBA? Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
External data import with a formula, fiormula is not evaluated
The Formula is very simple:
=RC(-1)&RC(1) It will only be evaluated when I enter the cell and leave it again. It seems that after it is being inserted through the get external data query it is treated as something that is not recognized by excel so that it does not evaluate it "Allllen" wrote: First suggestion: ToolsOptionsCalculationAutomatic, but I guess you will have tried that. Otherwise can you post the formula here. -- Allllen "Sierrraxray" wrote: I import data from a database into Excel. One of the fields contains a formula. However, the Formula is not evaluated after the import. All the rest works fine. Only if I enter the cell via F2 and then get out again the formual is evaluated. Is there a workaround, without using VBA? Thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
External data import with a formula, fiormula is not evaluated
The problem has been described from a different view angle in KB Article
135506. However, there is only a manual solution offered, by way of entering the cell via F2, similar to what I wrote. I am lokking for an automatic solution, however. Why does Excel not recognize a formula that is fetched from a database? Thanks "Allllen" wrote: First suggestion: ToolsOptionsCalculationAutomatic, but I guess you will have tried that. Otherwise can you post the formula here. -- Allllen "Sierrraxray" wrote: I import data from a database into Excel. One of the fields contains a formula. However, the Formula is not evaluated after the import. All the rest works fine. Only if I enter the cell via F2 and then get out again the formual is evaluated. Is there a workaround, without using VBA? Thanks |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
External data import with a formula, fiormula is not evaluated
You are referring to the offsets with the wrong style of bracket :
"=RC[-1] & RC[1]" NickHK "Sierrraxray" wrote in message ... The Formula is very simple: =RC(-1)&RC(1) It will only be evaluated when I enter the cell and leave it again. It seems that after it is being inserted through the get external data query it is treated as something that is not recognized by excel so that it does not evaluate it "Allllen" wrote: First suggestion: ToolsOptionsCalculationAutomatic, but I guess you will have tried that. Otherwise can you post the formula here. -- Allllen "Sierrraxray" wrote: I import data from a database into Excel. One of the fields contains a formula. However, the Formula is not evaluated after the import. All the rest works fine. Only if I enter the cell via F2 and then get out again the formual is evaluated. Is there a workaround, without using VBA? Thanks |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
External data import with a formula, fiormula is not evaluated
cmon this is due to german excel just like sometimes you have to use ;
instead of ,. I wrote that the formula works fine when I enter the cell via F2 and get out again! There is nothing wrong with the formula! "NickHK" wrote: You are referring to the offsets with the wrong style of bracket : "=RC[-1] & RC[1]" NickHK "Sierrraxray" wrote in message ... The Formula is very simple: =RC(-1)&RC(1) It will only be evaluated when I enter the cell and leave it again. It seems that after it is being inserted through the get external data query it is treated as something that is not recognized by excel so that it does not evaluate it "Allllen" wrote: First suggestion: ToolsOptionsCalculationAutomatic, but I guess you will have tried that. Otherwise can you post the formula here. -- Allllen "Sierrraxray" wrote: I import data from a database into Excel. One of the fields contains a formula. However, the Formula is not evaluated after the import. All the rest works fine. Only if I enter the cell via F2 and then get out again the formual is evaluated. Is there a workaround, without using VBA? Thanks |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
External data import with a formula, fiormula is not evaluated
Oh, I didn't realise I was suppose to guess you use the German version ?
Because what you posted errors in the English version. NickHK "Sierrraxray" wrote in message ... cmon this is due to german excel just like sometimes you have to use ; instead of ,. I wrote that the formula works fine when I enter the cell via F2 and get out again! There is nothing wrong with the formula! "NickHK" wrote: You are referring to the offsets with the wrong style of bracket : "=RC[-1] & RC[1]" NickHK "Sierrraxray" wrote in message ... The Formula is very simple: =RC(-1)&RC(1) It will only be evaluated when I enter the cell and leave it again. It seems that after it is being inserted through the get external data query it is treated as something that is not recognized by excel so that it does not evaluate it "Allllen" wrote: First suggestion: ToolsOptionsCalculationAutomatic, but I guess you will have tried that. Otherwise can you post the formula here. -- Allllen "Sierrraxray" wrote: I import data from a database into Excel. One of the fields contains a formula. However, the Formula is not evaluated after the import. All the rest works fine. Only if I enter the cell via F2 and then get out again the formual is evaluated. Is there a workaround, without using VBA? Thanks |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
External data import with a formula, fiormula is not evaluated
if you wanna help pls read the full text. in there i wrote that the formula is
"=RC(-1)&RC(1)... It will only be evaluated when I enter the cell and leave it again." this indicates that the formula is entered correctly, otherwise it would produce one of excels built in error messages. the problem is that excel siplays the formula as if it were text, although the format is general. even so, entering the cell via F2 and just leaving it again is enough so that excel evaluates the formula and displays the expected result. however this breaks the automation without additional code that i need to build into my excel sheet after importing data and formulas residing in a database do you have any clues what is going on? "NickHK" wrote: Oh, I didn't realise I was suppose to guess you use the German version ? Because what you posted errors in the English version. NickHK "Sierrraxray" wrote in message ... cmon this is due to german excel just like sometimes you have to use ; instead of ,. I wrote that the formula works fine when I enter the cell via F2 and get out again! There is nothing wrong with the formula! "NickHK" wrote: You are referring to the offsets with the wrong style of bracket : "=RC[-1] & RC[1]" NickHK "Sierrraxray" wrote in message ... The Formula is very simple: =RC(-1)&RC(1) It will only be evaluated when I enter the cell and leave it again. It seems that after it is being inserted through the get external data query it is treated as something that is not recognized by excel so that it does not evaluate it "Allllen" wrote: First suggestion: ToolsOptionsCalculationAutomatic, but I guess you will have tried that. Otherwise can you post the formula here. -- Allllen "Sierrraxray" wrote: I import data from a database into Excel. One of the fields contains a formula. However, the Formula is not evaluated after the import. All the rest works fine. Only if I enter the cell via F2 and then get out again the formual is evaluated. Is there a workaround, without using VBA? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import External Data | Excel Discussion (Misc queries) | |||
| import external data | Excel Discussion (Misc queries) | |||
| Import External Data | Excel Discussion (Misc queries) | |||
| PLEASE!! How can I un-grey the 'Data-Import External Data-Import Data' option ??? | Excel Programming | |||
| Import External Data | Excel Programming | |||
Linear Mode
