Office 365 activation error 0x80070005

When you install Office 365 and then start it, it might occure that the error messages 0x80070005 is shown and you are unable to activate it.

Usually you don't have to activate Office 365, since it is already "bound" to your online account.
So Office is automatically activated.

When you see this dialog, then there is a problem with rights on your system.
The simplest way to solve the problem is to run Word or Excel once as administrator.
Just right click on word and then select "Run as administrator" and you won't even see the activation stuff. It will be activated in the background and after closing word you just can use the office 365 suite as usual.

Excel file open problem when iCloud 2.x is installed

Sometimes users get a error message when they try to open a .xlsx file with Excel 2007 oder 2010.
The error message is like

"Excel found unreadable content in 'xxxxxx.xlsx'. Do you want to restore the content of this file? ...."

or in german:

"Von Excel wurde unlesbarer Inhalt in 'xxx.xlsx' gefunden. Möchten Sie den Inhalt dieser Arbeitsmappe wiederherstellen?

The funny thing is:

- When you have excel closed and double click the .xlsx file in Explorer it opens without a problem
- Also when you open it via the recently used files

- But when you open it via the file menu of Excel then it shows that error
- And then all other open requests show the same problem, until you restart excel


The cause of this problem is Apple iCloud in Versions 2.x and up.
So you have to remove the iCloud 2.x stuff and the problem is solved.
You can use iCloud 1.x, this gives no problems, just make sure you disable autoupdate for that thing...

Just wondering what the hell apple is doing there at them moment I try to open a excel file....


Some references:

https://discussions.apple.com/thread/4508650?start=0&tstart=0
http://www.office-loesung.de/ftopic550332_0_0_asc.php

Search (and replace) Newlines in Excel

Excel is a great tool for simple and easy data management.
But sometimes there are just limitations (of the user).

For example replace all new lines (line breaks) with some other character sequences.
It can be done, you just have to know how:

1. Open the search replace dialog
2. In the search field enter CTRL+j  (It's OK, it shows nothing)
3. In the replace field enter the new sequecne (For example \n or 0x0a etc.)
4. Hit on "Replace all"

That's it, the magic is done.
Of course microsoft does not tell you this in his offline/online help (For whatever reasons)