Error Message: There is insufficient memory or disk space. Word cannot display the requested font.

Issue: A users encountered error message: “There is insufficient memory or disk space. Word cannot display the requested font.” when he opens Word document. Beside Word, he also faces same issue for Excel and other Microsoft Office programs.
When he clicked on Fonts, there is only 2 type of fonts.

1) Go to \\%username%\AppData\Roaming\Microsoft\Templates
2) rename or delete file
3) Open Word again but still having the same error message

4) Go to Control Panel, Programs and Features
5) Right click on Microsoft Office 2010 and select Change
6) Select Repair and click Continue
7) After Repaired, restart computer.
8) Word able to open without error message.


Excel File is blank after exported from AMS system

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

If user checked the box for Unblock

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


  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
  6. Click ok
  7. Open the exported excel file. It will display information without prompt or error message.

Excel 2010 – There was a problem sending the command to the program. Error Message

Issue: User unable to open Excel files. Encountered “There was a problem sending the  command to the program”. error message.

1) Open Excel program
2) Click on File, Options, Advanced
3) Scroll down to General column
4) Uncheck the box for Ignore other applications that use Dynamic Data Exchange (DDE)
5) Click ok

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()


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

Company logo on header when open blank Excel

Issue: User wants to have company logo on header when he opens blank Excel 2010.

1) Open Excel 2010
2) Click on Insert tab, click on Header & Footer in Text Column
3) Click on Picture in Header & Footer Elements column to select picture for header
4) Click on Format Picture in Header & Footer Elements to adjust the picture’s size    if it is too big.
5) Click on File, Save
Filename must be Book.xltx
Save as type is Excel Template (*.xltx)
6) Save location must be C:\Program Files (x86)\Microsoft Office\Office14\XLSTART
7) Click Save
8) Close all Excel files and open Excel 2010 again.


Create Inventory List with drop list

1) In Sheet3 create data list

2) In Sheet1, create main inventory list

3) In sheet1, select A2 to A10 and click on Data Validation
In Allow column, select List
In Source column go to Sheet 3 click on Alice and press Shift key then click on  Wendy to select all
Click ok

3) Go back to Sheet 1, you will able to select user from the drop list

Final Product