treydog999 

[IMG]http://my.jetscreenshot.com/12147/m_20130513-0jzf-21kb.jpg[/IMG] was running the monte carlo got this error

Thanks for reporting, could you click debug and make a screenshot?

vvhg

vvhg 

Thanks for reporting, could you click debug and make a screenshot? vvhg

here you go

[IMG]http://my.jetscreenshot.com/12147/m_20130513-fmxc-161kb.jpg[/IMG]

Edit: I was also playing with target analysis. and its not picking up my trades. it only has FDAX sample trades in there.

treydog999 

here you go [IMG]http://my.jetscreenshot.com/12147/m_20130513-fmxc-161kb.jpg[/IMG] Edit: I was also playing with target analysis. and its not picking up my trades. it only has FDAX sample trades in there.

I tried on my side and everything works perfect, so I don't know how to track that error down...what version of Excel are you on?

Vvhg

vvhg 

I tried on my side and everything works perfect, so I don't know how to track that error down...what version of Excel are you on? Vvhg

Microsoft office professional plus 2010
excel version 14.0.4734.1000 32-bit

@vvhg

I mentioned this bug earlier but I must have forgotten to take a screenshot. Basically its not picking up the trades from my instruments only showing FDAX. Is there anyway for me to refresh it that it can pick up my trades? I don't know why I am struggling so much with this new version. Sorry for the inconvenience.

treydog999 

@vvhg I mentioned this bug earlier but I must have forgotten to take a screenshot. Basically its not picking up the trades from my instruments only showing FDAX. Is there anyway for me to refresh it that it can pick up my trades? I don't know why I am struggling so much with this new version. Sorry for the inconvenience.

Can you not manually refresh the pivot table? If not it would be connected to the other bug which basically is a pivot table refusing to refresh as far as I can see. I will look into it once I have the time.

Vvhg

vvhg 

Can you not manually refresh the pivot table? If not it would be connected to the other bug which basically is a pivot table refusing to refresh as far as I can see. I will look into it once I have the time. Vvhg

Nope, even if i unprotect the sheet and refresh all. I get "Reference is not valid" error.

@vvhg

I think I came up with a work around. I copy a new version of journal, then i unprotect the sheet and then put in Table1 as the new source, the entire selection of the journal tab. Does that give me the correct answers in the tables?

treydog999 

@vvhg I think I came up with a work around. I copy a new version of journal, then i unprotect the sheet and then put in Table1 as the new source, the entire selection of the journal tab. Does that give me the correct answers in the tables?

Thanks, I will look into this, maybe I can come up with a fix with this.
Do you have to do this once or every time you want to update the pivot table?

Vvhg

vvhg 

Thanks, I will look into this, maybe I can come up with a fix with this. Do you have to do this once or every time you want to update the pivot table? Vvhg

I have been doing it every time because I don't use the original copy as I don't want to break it.