Sunday, October 15, 2017

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

Saturday, September 2, 2017

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

Monday, July 24, 2017

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.

Friday, May 19, 2017

Google Mail (GMail) Back Up

Best tool for backing up all things Google is with something called Google Takeout. See an article describing it here: https://www.howtogeek.com/216189/how-to-create-and-download-an-archive-of-all-your-google-data/

You can directly access the location here: https://takeout.google.com/settings/takeout

Cannot Locate Contact after restoring the contact from "recently deleted" in GSuite

Another admin accidentally deleted an account instead of suspending it in GSuite. I went to "Recently Deleted Contacts" and restored the user, but was unable to find them in the Console under "Users." It turns out when you restore unfortunately, it won't appear in the console under "Users" until google propagates it which could take up to 24 hrs. If you want to check the status manually, go to "Admin Console" > " Apps" > "G Suite" > "Gmail" > "Email Addresses" Then you can see his account there, and suspend it.

Thursday, May 4, 2017

ISE Project Navigator crashes opening up a project

As stated in the subject, I ended up finding the solution here:
https://forums.xilinx.com/t5/Design-Entry/ISE-12-3-crashing-on-file-open/td-p/107305

Running Windows 10 x64, Xilinx ISE 14.7

Pasted below for posterity
------------------

For everyone trying to use Xilinx ISE 14.5 in Windows 8 x64.

Rename libPortability.dll to libPortability.dll.orig, and copy libPortabilityNOSH.dll to libPortability.dll.

Do this in:
C:\Xilinx\14.5\ISE_DS\ISE\lib\nt64
C:\Xilinx\14.5\ISE_DS\common\lib\nt64 (copy dll from first location)

This turns off SmartHeap.

This will fix ISE and iMPACT crashes on file dialogs.
------------------

Saturday, April 15, 2017

Word Cross-Reference Pop-up Menu is not Appearing

Working on my journal and word isn't helping me out. Turns out there is a bug for multiple monitor setups:

You need to
  1. Close out all instances of Word
  2. Re-open the file
  3. Move Word to a different window
  4. Click on Cross References again
 source