›

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Register

Quick Links

Categories

Error message

rmweiss12rmweiss12
in General
During running a Refresh I am getting the attached error message. The program stops at that point and nothing is updated.
Can you help please?



Comments

  • VidasMatelisVidasMatelis
    Please carefully review transactions - most likely you have same "bad" transactions - like selling symbol you do not have in that account. If you cannot see the issue, please do following:
    1. Take original Excel workbook "Master" and make a "Copy" version.
    2. Open "Copy" version and delete last 10 transactions and attempt to refresh. If refresh works, review carefully these last 10 transactions in master copy and try to refresh.
    3. If refresh fails, then remove another 10 last transactions and repeat until you know transactions that cause this.
    4. When issue is identified, fix it in the Master workbook.
  • rmweiss12rmweiss12
    Thanks for the tips. Actually, I found the error. It was indeed a bad transaction. By mistake, I put a date in the exchange rate column which inflated the Total Amount for that single transaction to a very high number (>200 million). That was enough to screw things up. It is now working.
Sign In or Register to comment.