Stop word from updating references when you save as pdf or print

I really mainly have problems when my inserted references look like this: [4]-[6] and I want them to look like this [4-6]. If you edit them, normally in word when you click save as PDF it changes everything back to the first format. To avoid this you can "lock the fields" and just press ctrl+f11 to lock it, and ctrl+shift+f11 to unlock it. I haven't found a way to determine in properties if something is locked or not, but if after you finish your dock, you click ctrl+a then ctrl+f11, you lock everything nicely.

"File>Options>Display and uncheck the "Update fields before printing" may do it.  Or, it may be necessary to use Ctrl+A (to select everything) and then Ctrl+F11  to Lock the fields, or Ctrl+Shift+F9 to Unlink them."

source: here

Fixing Comment Box Proofing in word files in a document originally created in another language

Ran into a problem today. The collaborators for the project we are working on are foreign so the document they sent me is defaulted to their native language. The challenge is you can simply change the proofing language Review > Language > Set Proofing Language ...  however I noticed when I added comments they still retained the original language. The quick fix for this is:

1. Show the "Styles" by clicking the Expand Box in the Styles section of the [Home] Tag ribbon
2. Click [Options]
3. Change "Selected Styles to Show:" to all styles 
4. In the style window right click on the Comments Text > Modify 
5. [Format] > Language > Select English! 

Source: Here

Default Shipping Address in Amazon Checkout Cart is not modified by the "Manage Addresses" page

For some reason even if I set the default address in Manage Addresses on Amazon, that default address would not appear when I went through checkout normally. I finally identified this problem to being, a different address was set in my Fire Tablet Amazon App. Extremely Frustrating the tablet settings always override the webpage ones.

Game Bar Prevents Steam Overlay

When you first plug in an Xbox controller, you will see a pop-up for the game bar if you click the Xbox button. To turn off this feature so you can use the steam overlay in big picture mode do the following:

In Steam, press Win+G or Xbox button to open Game bar (choose "Yes, this is a game.")
Open the settings (cog icon) on Game bar and uncheck "Open Game bar using [Xbox logo] on a controller"
Uncheck "Remember this as a game" and Game bar should close
Now Game bar won't open when pressing the Xbox button anymore (seems to be global) and the Xbox button works as expected again in Big Picture mode. To open Game bar later, press Win+G.

Source: here

When saving a word document all comments become by "Author"

As stated in the subject, it is hugely annoying when you are trying to review papers from multiple people that have been passing along a draft if this happens. You need to :

In Word 2010, go to File->Options->Trust Center->Trust Center Settings. Then, uncheck "Remove personal information from the file properties on save"

In Word 2013, it falls under File -> Options -> Trust Center -> Trust Center Settings... -> Privacy Options. It is found under the Document-specific settings section.

 
Source:  here

Different Colors for Labels on Axis in Graph/Chart for Excel

I needed to come up with a way to have the labels different colors to add additional categorization my charts. I had seen a co-worker do this before, but he make several copies of the same graph with different colors and then just used paint to edit them. Turns out there is a much simpler answer here:
Link

Short Ver.

• Create a separate column for each colored label, and have the output be Zero or #N/A
• Change the plot of these to "Line Chart"
• Click on the label and select "Category Name" uncheck the rest
• Under the labels set the alignment label position to "below" 
• Click on the actual lines and hide them 
• Change the color of the labels 

Okay, lets say you copied the chart and the labels disappeared. 

•  Add the legend back if you removed it
• Click on the legend marker for labels "it should still be there even if there is nothing" change the color so it appear son the graph
• Right click on the line, and click "Add Data Labels" 
• Now you can edit it just like above, just make sure to make the line no color again afterwards

Teamviewer still prompts for confirmation in saved computer contacts when unattended access is setup

The issue. I click connect, and it prompts the other computer for a confirmation....no idea why that started. This was the only computer that did it. You just, unfortunately have to uninstall and reinstall.