Excel File is blank after exported from AMS system

Issue: When user opened the Excel files which exported from AMS system, no information displayed.
blank_excel

If user checked the box for Unblock
Report_unblock

Click Yes
Yes_excel
User will able to see the information exported from AMS system.

Solution:

  1. open Excel program
  2. Click on File, Options, Trust Center
  3. Click on Trust Center Settings… button
  4. Click on Protected View (left pane)
  5. uncheck Enable Protected View for files originating from the internet and Enable Protected View for files located in potentially unsafe locations
    TrustCenter
  6. Click ok
  7. Open the exported excel file. It will display information without prompt or error message.

Windows Server – Disable Password Complexity Requirements

Local Security Policy:
1) Go to Control Panel, Administrative Tools
2) Double click on Local Security Policy
3) Click on Account Policies, Password Policy
4) (On the right pane) Set Disable for Password must meet complexity requirements
5) Set 0 days for Maximum password age

Group Policy:
1) Type gpmc.msc in Run command.
2) Double click on Forest:xx.local, Domains, xx.local
3) Right click on Default Domain Policy and select Edit
4) Click on Computer Configuration, Policies, Windows Settings, Security Settings, Account Policies
5) (on the right pane) Double click Password Policy
6) Set Disable for Password must meet complexity requirements
7) Set 0 days for Maximum password age
8) Type gpupdate /force in Run command

Auto-run Application after login to Windows 10

Issue: User wants to have Outlook auto-open first after he login to Windows.

Solution:
1) Press Windows key and R key (Run window appears)
2) Type in shell:startup and click Ok (Startup folder appears)
3) Right-click on empty space and select New, Shortcut
4) Browse to Outlook’s Location and click Ok
     My Outlook 2010’s location – C:\Program Files (x86)\Microsoft  Office\Office14
5) Click Next and Finish
6) Done

Reference:

Where is the Startup folder in Windows 10?

Unable to delete old hard drive’s partition in Disk Management

Issue: I wanted to use faulty laptop’s old hard drive as external drive but i when i trying to delete all partition, i were only able to delete drive C, other partitions like Recovery, System and Reserved etc doesn’t have the option to delete.

Solution:
Using DISKPART command in command prompt
1) Run command prompt as administrator

2) Type diskpart

3) Type list disk
4) Type select disk 1 (disk 1 is the old hard drive)
5) Type list partition ( it displays partitions have not deleted)
diskpart01

6) Type select partition=1 (select the first Recovery partition to delete)
7) Type delete partition override (delete partition)
8) repeat step 6 and 7 to delete rest of the partitions
diskpart02

9) Type exit (to exit DISKPART)
10) Go to Disk Management, old hard drive’s partitions have been deleted.
diskpart03

Exchange Server 2013 – Change message size limit

Beside changing the Maximum send size (for send connectors) and Maximum receive size (for receive connectors) in ECP (Exchange Admin Center).

In Exchange Management Shell, need to change Global Transport configuration settings.

To change Global Transport configuration settings for  MaxSendSize  to 30MB & MaxReceiveSize to 50MB:
Set-TransportConfig –MaxSendSize 30MB –MaxReceiveSize 50MB

To double check:
Get-TransportConfig | ft MaxSendSize, MaxReceiveSize
Get-SendConnector | ft name, MaxMessageSize
Get-ReceiveConnector | ft name, MaxMessageSize

Reference:
https://rajisubramanian.wordpress.com/2014/01/26/exchange-server-2013-message-size-configuration-detail/

Auto display current date when open Excel file

I have IT acknowledgement form for users to sign off when they received laptops from me.

Instead of every time i type in the date, i set a cell using Today function:

1) Right click on the cell and select Format Cells…
2) Click on Number tab, select Date in the Category
3) Select the type of format you prefer, mine is 14-Mar-01
4) Type in the function =TODAY()

excel_toay

5) Every time i open this file, it will display current date.

Create Windows 10 Setup USB Flash Drive

Create your own Windows 10 setup USB flash drive for future installation:

1) Obtain Windows 10 Product key using Belarc Advisor (http://www.belarc.com/free_download.html).
2) Go to http://www.microsoft.com/en-us/software-download/windows10
3) Click on Download Tool Now (64-bit version) – for 64bit windows.
4) Run MediaCreationToolx64.exe
5) Select Create installation media for another PC
win10_1
6) Select Language, Edition and Architecture based on your Windows
win10_2
7) Select USB flash Drive
win10_3
8) Follow on-screen steps

Upgrade to Windows 10 manually

Some of the users didn’t receive the Window 10 upgrade alert (GWX) on their taskbar. Therefore not able to upgrade to Windows 10.

There is another way to upgrade your Windows:
1) Go to http://www.microsoft.com/en-us/software-download/windows10
2) Click on Download Tool Now (64-bit version) – for 64bit windows. You can check it by going to Control Panel, System. There will show you your Windows edition and System Type.
3) Run MediaCreationToolx64.exe
4) Select Upgrade this PC now and click Next
upgrade
5) Follow on-screen to complete your Windows upgrade
6) After Windows upgrade, remember to save a copy of your computer info (which includes Windows Product key) using Belarc Advisor (http://www.belarc.com/free_download.html).

Acer Veriton – Acer eRecovery Management (updated included others)

Alt + F10 key

When you power on computer, Acer logo appears.
Immediately press above keys to get in Acer eRecovery Management.

Reference:
http://acer.custhelp.com/app/answers/detail/a_id/2631/session/L2F2LzEvdGltZS8xNDQ2MDg4ODcxL3NpZC9IRFRHaDdBbQ%3D%3D

——————————————————————————————

Reference:
http://www.computerhope.com/jargon/h/hiddpart.htm

  • Alt + F10 – This key combination will access Acer disk-to-disk (D2D) recovery partition. Note: you may need to enable the D2D option in CMOS setup.
  • F9 – Access ASUS EEE PC hidden partition
  • F10 or F11 – Access the Compaq (Hewlett Packard) recovery partition
  • Ctrl + F11 or F8 – Access Dell computers Dell System Restore (DSR) partition
  • F11 or Alt + F10 – Access eMachine option to restore a backup copy
  • F11 – Access Gateway hidden restore partition
  • F11 – Access Lenovo hidden recovery partition
  • F10 – Access Sony hidden restore partition
  • 0 (zero key) or F8 – Access Toshiba hidden partition