ExcelAsyncUtil.Observe returning ExcelErrorNA

Jan 8, 2014 at 8:20 PM
I have some Excel DNA plugins that were implemented approximately a month ago. Without any code changes, all the observables stopped working. The function call

ExcelAsyncUtil.Observe

No longer returns the observer I expect, but an ExcelErrorNA. What might be causing this? Is it possible something in excel has changed?

Very puzzled.

Thanks,
Ryan
Jan 8, 2014 at 8:54 PM
Run also returns ExcelErrorNA. I tried this simple function

public static object SleepAsync(string ms)
    {
        return ExcelAsyncUtil.Run("SleepAsync", ms, delegate
        {
            Debug.Print("{1:HH:mm:ss.fff} Sleeping for {0} ms", ms, DateTime.Now);
            Thread.Sleep(int.Parse(ms));
            Debug.Print("{1:HH:mm:ss.fff} Done sleeping {0} ms", ms, DateTime.Now);
            return "Woke Up at " + DateTime.Now.ToString("1:HH:mm:ss.fff");
        });
    }

returns the same thing.
Coordinator
Jan 8, 2014 at 10:15 PM
Hi Ryan,
  1. Is your workbook set to automatic calculation?
  2. Do you have anything in the Disabled Add-Ins list?
  3. Can you check the RTD ThrottleInterval?
  4. Is you assembly markes as 'Register for COM Interop'? It should not be.
-Govert
Jan 9, 2014 at 1:53 AM
Is your workbook set to automatic calculation?
Automatic

Do you have anything in the Disabled Add-Ins list?
Yes, but no other excel dna addins

Can you check the RTD ThrottleInterval?
How can i check this?

Is you assembly markes as 'Register for COM Interop'? It should not be.
It't not.
Jan 9, 2014 at 1:46 PM
Can you check the RTD ThrottleInterval?
2000

Odd thing about this, we didnt change any code. It seems like something else changed on these machines, possibly from a windows update. No clue