Regarding regeneration problems, we have had the same problem.
Today the assembly regenerates fine, status = green, no warnings, etc.
Tomorrow, the same assembly opens yellow, or even blows up and we end up
in failure resolve mode.
Sometimes this is related to a subcomponent (that was not changed) going
through a regeneration and losing its mind.
How can this happen?
Is there a way to "deep-regenerate" ensure there are no hidden problems?
For a while I was using model player, checking regenerate every feature,
and it was finding the problem sometimes but it still did not catch
every time.
Regarding spreadsheets, its long time past that Pro should play nice
with Excel.
Regards,
Walt Weiss