office
Each time an account is linked to the Windows installation, a registry entry is set, but it is not deleted when you link a new account to the Windows installation. This registry entry has to be removed by hand. To do so press the Windows key + R, type “regedit” and press enter. Here you have to navigate to HKEY_USERS -> $ID of your Windows User$ -> Software -> Microsoft -> Office -> 16.0 -> Common -> Identity -> Identities. In here you will find an entry with a seemingly random name. Search them all for an entry that contains the email address of your old Microsoft subscription account and delete it.
Most of the times after this the installation should work. Sometimes you also have to uninstall Office entirely and reinstall it.
Microsoft Office 365 Abo from TU Wien
TU Wien offers software for students. One software is a Microsoft Office 365 subscription for students to a good price. For this subscription, you receive a Microsoft account to login and download the software you need. After one year this subscription expires and you have to buy a new subscription and receive a new Microsoft account login. When I bought the subscription for the second year, the account on my Windows 8 notebook was not updated to the new credentials, even after multiple successful login attempts. I could not use the Microsoft Office, because it still ran on my old expired account.
How to effectively create common documents (Word, Excel, Powerpoint...) collaboratively?
With common file sharing systems like SugarSync or Dropbox it is not effective for a group to work on the same document at the same time because one cannot know what part another one is working on at the very same time. Furthermore, parts of the document can be lost:
1. Person A opens the document and starts working
2. Person B saves the document with changes made after person A opened it
3. Person A saves the now obsolete document. So the part of person B gets lost.
How to address the issues mentioned above, how can multiple persons work effectively and collaborative on the same document?
Taggings:
Absolute references in Tables in Excel 2007
In MS Excel 2007 there are 3 types of cell references: absolute, relative and mixed. The use of correct type of reference provides correct behavior when dragging of the formula using references to other cells:
<ol>
<li><strong>Absolute</strong> e.g. $A$1
An absolute reference is not changed while dragging. For instance in cell A1 is number 100. In cell B1 we enter a formula <code>=$A$1</code>. Dragging of B1 to B2 or C1 will not change the behavior of the formula in B2 or C1 i.e. all 3 cells with the formula will show value 100.
</li>
<li><strong>Relative</strong> e.g. A1
A relative reference is changed in both directions while the formula is dragged. Let A1 is containing number 100, A2=200 and B1=300. We enter the formula formula <code>=A1</code> in C1. Afterwards we drag the formula into C2 and D1. The formulas in these cells will be altered so that C2 and D1 will contain formulas <code>=A2</code> (shows 200) and <code>=B1</code> (shows 300) respectively.
</li>
<li><strong>Mixed</strong> e.g. $A1
A mixed reference is dynamically changed in one direction only e.g. $A1 has a absolute column and relative row reference.
</li>
</ol>
The problem is that such notation is not working when using tables in Excel 2007. We want to find out how to make a absolute reference to the whole column of a table.
The syntax of relative reference to Column1 of Table1 is <code>=Table1[Column1]</code>
Taggings:
