Errors in Linked Tables

[cr731]

I'm having an impossible time with a linked table in Powerpivot. Every time I change the source data and refresh, I get this:

"There were errors trying to update one or more linked tables. Use Options below to see ways to fix these problems, or OK to continue without fixing them."

None of the "Options below" are remotely helpful. I've narrowed it down to a few calculated columns that are all doing a SUMIF type formula:

=CALCULATE(SUM[Current Year Sales],ALLEXCEPT(MyTable,MyTable[Customer+Product Combination]))

If I delete the calculation in the column and then Update, it Updates fine. And even then if I type back the same formula, it calculates correctly.

But if I try to update my table with that formula in place, I get the error. I've tried changing the Data Type to every type available and still nothing.

What is going on....?

 

[scottsen]

I don't recall seeing this. My only theory would be to wrap it in an IFERROR()... but honestly, I doubt that is going to help

Can you ... NOT have that as a calc column (put it in a measure)?