_xlbgnm. Appears in Live data feed cell after startup.

I have a live DDE data feed from MT4 into a excel 2010 , when I shut down and restart, _xlbgnm. appears in SOME cell formulas.

If I remove it all runs ok, there are lots of other live data cells running which never get a problem, it's only a particular type.

In my case SP500, UK100, GER30 and JPY225 index's the others EURUSD Forex quotes are ok all the time.

Here’s what appears in the cell ='MT4'|LOW!_xlbgnm.SPX500 and when I remove ='MT4'|LOW!'SPX500' which then works fine. It appears in all the index cells for HIGH, LOW, BID & ASK.



Any ideas what this means... Google does not have any answers. I think it maybe a failure to read a the dde feed on start up. If so how could I prevent this occurring.



Thanks

Actually my way may sound bit more traditional but I have managed to resolve this issue for now.
I had the same issue, couldnt find the cause of the problem so I have resolved the problem by writing a short VBA code.

Please Login or Register  to view this content.

If you can write code for all the cells with error and then set it for auto run. This should resolve your problem for now until you find a solution.

To set it for auto run you may write -

Please Login or Register  to view this content.

So with the help of this, when ever you open your excel file and enable macros your problem should be solved.

Hope this helps.

Hi

Thanks for your reply and helpful information.

Looks like I may have to learn to VBA code, it have to happen eventually

Could you explain the code a bit more? Does E5 represent the cell and do I have to write seperate code for each cell?

Thanks again.

Hi

Yes, the cell reference has to be mentioned first

If you need for just one cell than you can copy and past this code in your macro

Please Login or Register  to view this content.

This is just for one cell that has a Bid price for S&P 500. you can just copy the same code down and just change the cell reference and the product details.
Once you have got this macro, you can assign it to a button if you wish to do it manually or could just automate it as i mentioned in my first reply.

This should certainly resolve your issue.

Hi JM,

I have the same issues and tried your instructions although that is not resolving the case. I am writing the following codes that are working OK for all other symbols bur for SP500 is not working:

Sub Errorsolution()

Range("M14").Select
ActiveCell.FormulaR1C1 = "='MT4'|ASK!'SP500'"

Range("L14").Select
ActiveCell.FormulaR1C1 = "='MT4'|Time!'SP500'"

End Sub


The formulas are changed to 'MT4'|ASK!_xlbgnm.SP500 and 'MT4'|Time!_xlbgnm.SP500;

can you help on this?