Omniture Excel Client Almost Ruined My Day

So............... when hitting "refresh all" in a spreadsheet full of data blocks you worked for two days on, make sure you don't have another spreadsheet open that has corrupted data blocks in them, because this will in turn corrupt your brand new ones by trying to pull an alien like maneuver in trying to forcibly attach themselves to your new set of data blocks.  When you then go to save said document, it will crash MS Excel over and over and over again.... Thereby forcing you to go through and remove all the bad data connections in order to get the document to save.  If you do not follow this advice it will put a serious damper on your morning.

Comments

[Ben Gaines]

Andrew,

That's a strange one; I can't say that I've heard of it before. I hope you submitted it to ClientCare; I have no idea how refreshing one sheet could corrupt another one. It's entirely possible that aliens are involved.

Please let me know if there is anything I can do to help; you know where to find me :)

Thanks,

Ben Gaines
Product Manager
Adobe Systems, Inc.

[Brandon]

I am having the same issue. I run XL client for Omniture and, after refreshing, everything looks fine. Hit "save" and the system crashes. Can't "save as" either. I even restarted my computer and it still crashes on save. It seems to have corrupted my file.

[Andrew Sprung]

need to remove all of your corrupted data sources that should do the trick

[Jim]

Is there a way to tell which data connections are corrupted? I have this problem in spades when I build a file that has numerous connections, but there's no way to tell which one is corrupted.

[Andrew Sprung]

yeah i had to go through each of mine and look, good way to check in the data tab in excel and click on "connections" and check each of them... tedious but worked for me