Excel 2013 Errors in Linked Tables; An Answer
i'm posting in case else has problem save month have spend trying track down. ms paid support couldn't work out. error reporting in 2013 version useless , less informative 2010. if see
"there errors trying update 1 or more linked tables. use options below see ways fix these problems, or ok continue without fixing them." , go options wreck model don't panic. have found 2 causes
1. if have incompatible data in 1 of import fields e.g. date entered style 07/29/13 when date format uk 29/07/13, or text. in 2010 got incompatible data error above.
2. if update table has calculated field dependency on table can't find same error. found because updating weekly figures , updated tables 1 @ time in wrong order.
broadly think error created on import throw same warning. hope message saves people lot of heart ache.
mike
"there errors trying update 1 or more linked tables. use options below see ways fix these problems, or ok continue without fixing them." , go options wreck model don't panic. have found 2 causes
1. if have incompatible data in 1 of import fields e.g. date entered style 07/29/13 when date format uk 29/07/13, or text. in 2010 got incompatible data error above.
2. if update table has calculated field dependency on table can't find same error. found because updating weekly figures , updated tables 1 @ time in wrong order.
broadly think error created on import throw same warning. hope message saves people lot of heart ache.
mike
hi mike,
thank point out.
regards,
we trying better understand customer views on social support experience, participation in interview project appreciated if have time.
helping make community forums great place.
SQL Server > SQL Server Analysis Services
Comments
Post a Comment