Carnegie Mellon University Open Learning Initiative PC Hardware (Open + Free)

https://oli.cmu.edu/jcourse/webui/guest/join.do?section=pc-hardware

Carnegie Mellon University
Open Learning Initiative
PC Hardware (Open + Free)

Can open Excel files locally but not from network

 

Can open Excel files locally but not from network

Problem: 

Can open Excel files locally but not from network

Solution:

File -> Options -> Trust Centre -> Trust Centre Settings -> Protected View.

Clear all the ticks. Click OK.

Can not open PPT

 Can not open PPT

Symptom: 

When opening a PPT, 'PowerPoint found a problem with content in xxx.pptx. PowerPoint can attempt to repair the presentation.

If you trust the source of this presentation, click Repair.'

After you click 'Repair', you get

'There was an error accessing xxxxx.pptx.'

If you click 'Show Help', you get

'This error can be caused by the following conditions:

. Your hard drive or floppy drive has a corrupt section (damaged track or sector).
. A temporary operating system or network failure has occurred.
. Your network is unavailable, slow, or is corrupting data packets (failure of a router, network card, or noise on the network transmission line).
. Your antivirus program may be causing problems accessing certain files.

In the case of a damaged disk, you must save the file to another location (for example, a different drive).

In the case of a failure of the operating system, ...

If the network is experiencing problems, ... consult your network administrator.'

You click OK, you see nothing.

Solution: 

Click 'File -> Options -> Trust Centre -> Trust Centre Settings... -> Protected View',

Clear all the tick marks. Click OK.

You open the .pptx file fine now.

Excel: How to Troubleshoot Excel opening blank when you double-click a file icon or file name

Excel: How to Troubleshoot Excel opening blank when you double-click a file icon or file name

Excel: How to Troubleshoot Excel opening blank when you double-click a file icon or file name

Content provided by Microsoft

Applies to: Excel 2013Excel 2010Microsoft Office Excel 2007Excel 2016 More

---

Select Product Version

All Products

Symptoms

---

When you double-click an icon or file name for a Microsoft Excel workbook, Excel starts but displays a blank screen where you expect the file to appear.

Resolution

---

To resolve this problem, try the following methods, as appropriate, in the given order.

Hide all

Method 1: Ignore DDE

This problem may occur if the Ignore other applications that use Dynamic Data Exchange (DDE) check box in Excel options is selected.

When you double-click an Excel workbook in Windows Explorer, a dynamic data exchange (DDE) message is sent to Excel. This message instructs Excel to open the workbook that you double-clicked.

If you select the "Ignore" option, Excel ignores DDE messages that are sent to it by other programs. Therefore, the DDE message that is sent to Excel by Windows Explorer is ignored, and Excel does not open the workbook that you double-clicked.

To correct this setting, follow these steps:

1. On the Tools menu, click Options.
2. Click the General tab.
3. Clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box, and then click OK.

Note For more information about how to turn off DDE, see the following Microsoft Knowledge Base article:

211494 "There was a problem sending the command to the program" error in Excel

If these steps do not resolve the problem, go to Method 2.

Method 2: Repair User Experience Virtualization (UE-V)

If you are running Update User Experience Virtualization (UE-V), install hotfix 2927019. To do this, see the following Microsoft Knowledge Base article:

2927019 Hotfix Package 1 for Microsoft User Experience Virtualization 2.0

If you are not sure whether you are running UE-V, examine the program list in the Programs and Features item in Control Panel. An entry for “Company Settings Center” indicates that you are running UE-V.

If these steps do not resolve the problem, go to Method 3.

Method 3: Reset file associations

To check whether the file associations in the system are performing correctly, reset the Excel file associations to their default settings. To do this, follow the steps for your operating system.

Windows 8

1. On the Start screen, type Control Panel.
2. Click or tap Control Panel.
3. Click Default Programs, and then click Set your default programs.
4. Click Excel, and then click Choose default for this program.
5. On the Set Program Associations screen, click Select All, and then click Save.

Windows 7

1. Click Start, and then click Control Panel.
2. Click Default Programs.
3. Click Associate a file type or protocol with a specific program.
4. Select Microsoft Excel Worksheet, and then click change program.
5. Under Recommended Programs, click Microsoft Excel.
6. If Excel does not appear in this list, click Browse, locate the Excel installation folder, click Excel.exe, and then click Excel.

If these steps do not resolve the problem, go to Method 4.

Method 4: Repair Office

Try to repair your Office programs. To do this, follow the steps for your installation type and operating system.

For an Office 365 Click-to-Run installation

Windows 8

1. On the Start screen, type Control Panel.
2. Click or tap Control Panel.
3. Under Programs, click or tap Uninstall a program.
4. Click or tap Microsoft Office 365, and then click or tap Change.
5. Click or tap Online Repair, and then click or tap Repair. You may have to restart your computer after the repair process is finished.

Windows 7

1. Click Start, and then click Control Panel.
2. Double-click Programs and Features.
3. Click Microsoft Office 365, and then click Change.
4. Select Online Repair, and then click Repair.
   
   Note You may have to restart your computer after the repair process is complete.
   
   

For an Office 2013, Office 2010, or Office 2007 installation

To repair Office 2013, Office 2010, or Office 2007, follow the steps in the following Office website topic:

Repair Office programs

If these steps do not resolve the problem, go to Method 5.

Method 5: Turn off add-ins

Excel and COM add-in programs can also cause this problem. These two kinds of add-ins are located in different folders. For testing, disable and isolate the conflict by turning off each add-in one at a time. To do this, follow these steps:

1. On the File menu, click Options, and then click Add-Ins.
2. In the Manage list at the bottom of the screen, select COM Add-Ins item, and then click Go.
3. Clear one of the add-ins in the list, and then click OK.
4. Restart Excel by double-clicking the icon or file name for the workbook that you are trying to open.
5. If the problem persists, repeat steps 1-4, except select a different add-in in step 3.
6. If the problem persists after you clear all the COM Add-ins, repeat steps 1-4, except select Excel Add-Ins in step 2, and then try each of the Excel add-ins one at a time in step 3.

If Excel loads the file, the add-in you last turned off is causing the problem. If this is the case, we recommend that you visit the manufacturer's website for the add-in to learn whether an updated version of the add-in is available. If a newer version of the add-in is not available, or if you don’t have to use the add-in, you can leave it turned off.

If Excel does not open the file after you turn off all the add-ins, the problem has a different cause.

If these steps do not resolve the problem, go to Method 6.

Method 6: Disable hardware acceleration

To work around this problem, disable hardware acceleration until a fix is released by your video card manufacturer. Make sure to check regularly for updates to your video card driver.

To disable hardware acceleration, follow these steps:

1. Start any Office 2013 program.
2. On the File tab, click Options.
3. In the Options dialog box, click Advanced.
4. In the list of available options, select the Disable hardware graphics acceleration check box.
   
   The following screen shot shows this option in Excel.
5. Click OK.

Note For more information about hardware acceleration, see the following Microsoft Knowledge Base article:

2768648 Performance and display issues in Office 2013 client applications

If you still experience this problem after you try all these methods, contact Microsoft Support for additional troubleshooting help.

You cannot use Outlook to complete a Microsoft Word Mail Merge

You cannot use Outlook to complete a Microsoft Word Mail Merge

Symptoms

---

You use Microsoft Word to start a Mail Merge that is configured to send email messages to the recipients. However, Microsoft Outlook does not send the email messages. In some cases, you do not receive an error message. Or, you may receive the following error message:

Word could not load the e-mail envelope. This could be caused by a network connection problem or a problem with your Office installation.

Cause

---

If you are using Microsoft Outlook 2002, Microsoft Office Outlook 2003, or Microsoft Office Outlook 2007, this issue may occur if you install a newer version of Microsoft Office and then uninstall the newer version. This issue also occurs when you install a trial edition of a newer version of Microsoft Office.

If you are using Microsoft Outlook 2010, this issue may occur if you install the 64-bit version of Microsoft Office 2010 or of Microsoft Outlook 2010, you uninstall the 64-bit version, and then you install the 32-bit version.

Resolution

---

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:

322756 How to back up and restore the registry in Windows

Outlook 2002, Outlook 2003, or Outlook 2007

To resolve this issue for Outlook 2002, for Outlook 2003, or for Outlook 2007, follow these steps:

1. Exit all Microsoft Office applications.
2. Start Registry Editor:
   • In Windows Vista or in Windows 7, click Start, type regedit in the Start Search box, and then press Enter.
     
     
     If you are prompted for an administrator password or for confirmation, type the password, or provide confirmation. 
   • In Windows XP, click Start, click Run, type regedit in the Open box, and then click OK.
3. Locate and then click the following registry subkey: 
   
   HKEY_CLASSES_ROOT\TypeLib\{00062FFF-0000-0000-C000-000000000046}
4. On the Edit menu, click Delete.
5. Exit Registry Editor.
6. Repair or reinstall the Microsoft Office program.

Outlook 2010

To resolve this issue for Outlook 2010, follow these steps:

1. Exit all Microsoft Office applications.
2. Start Registry Editor:
   • In Windows Vista or in Windows 7, click Start, type regedit in the Start Search box, and then press Enter.
     
     
     If you are prompted for an administrator password or for confirmation, type the password, or provide confirmation. 
   • In Windows XP, click Start, click Run, type regedit in the Open box, and then click OK.
3. Locate and then click the following registry subkey:
   HKEY_CLASSES_ROOT\TypeLib\{00062FFF-0000-0000-C000-000000000046}\9.4\0\win64
4. On the Edit menu, click Rename.
5. Type BAKwin64, and then press Enter.
6. Exit Registry Editor.
7. Repair the Microsoft Office 2010 or Microsoft Outlook 2010 installation.
   • In Windows Vista or in Windows 7, click Start, type programs and features in the Start Search box, and then press Enter.
   • In the list of installed programs, right-click Microsoft Office 2010 or Microsoft Outlook 2010, and then click Repair.

PowerPoint Won't open network files

PowerPoint Won't open network files

We can also try disable Protected View to see if it helps. To do this, please follow:

1. Open a PowerPoint file.

2. Click File > Options > Trust Center > Trust Center Settings.

3. Click Protected View from the left panel.

4. Clear all the three check boxes and click OK.

If above doesn't work, please also try testing with a new Windows user profile.

Can not open Internet Explorer

Can not open Internet Explorer

Solution:

Steps:
1. Click 'Start'. Type 'cmd'. Righ-click 'cmd'. Choose 'Run as Administrator'.
2. type in the following command -
>regsvr32.exe "c:\program files\internet explorer\ieproxy.dll".
You will get a successfully registered message.
3. Restart your computer.

USB Device - Advanced Repair

USB Device - Advanced Repair

Problems:

Your computer can not find your Flash drive or SD card? or any other problem of your USB devices?

Solution:

U盘为什么要量产？

U盘量产网

Step 1: Download ChipGenius, software for assisting users in extracting information about their USB devices, finding out details they need to repair broken flash drives.

Step 2: Run ChipGenius, and find the model number (e.g. PS 2251-07) of the control chip of a USB device (e.g. flash drive).

Step 3: Go to U盘量产网 and find the specific mass production tool for that specific control chip model (e.g. 'PS 2251-07'). Download the tool (e.g. the one on the page - 群联MPALL 7F V5.03.0A量产工具DL07中文版 )

Step 4: Find the tutorial for using the tool (e.g. 金士顿U盘PS2251-07东芝闪存白片量产CDROM成功教程 )

Step 5: Run the tool. Follow the tutorial. The bad flash drive or SD card will be repaired.

(Done)

Double-clicking an Excel file can NOT open it

Double-clicking an Excel file can NOT open it


It gives an error message - 'there was a problem sending the command to the program'.

Solution:

• Open Excel 2007.
• Open the Menu in the top left.
• Click the "Excel Options" button.
• Click the advanced tab on the left of the options screen.
• Under the general options uncheck the box "Ignore other application that use Dynamic Data Exchange (DDE)"

How to check if a port is open or blocked?

How to check if a port is open or blocked?

Method 1: Use 'Netcat' (alias: 'nc')
                  nc -zvv IP port

Method 2: http://www.canyouseeme.org/

Method 3: http://www.yougetsignal.com/tools/open-ports/

When opening a PDF file, the page flashed and became blank, then closed

When opening a PDF file, the page flashed and became blank, then closed

Solution: Exit the Chinese hand-writing software.

How to open an .mdf file? (How to attach a database to MS SQL Server?)

http://www.youtube.com/watch?v=rhIr9Qf-oHw

Received a Word attachment in Outlook, but it is blank

http://www.howto-outlook.com/faq/securetemp.htm

Error opening attachments / Cleaning out the Temporary Outlook Files folder

When opening an attachment directly from within Outlook you could get an error message saying that it can’t create the file and to that you need check the permissions on the folder you want to save it in. In most cases the permissions on the folder isn’t the issue but the fact that the folder is “full”. When you open an attachment directly from within Outlook it will first save a copy to a subfolder of the Temporary Internet Files folder. Cleaning out the folder will solve the issue.

Outlook Secure Temp folder

Unfortunately this is easier said than done. The subfolder name Outlook creates (on installation of Outlook) in the Temporary Internet Files folder is quite random. In Outlook 2003 and previous, the name starts with OLK and is followed by up to 4 random numbers or letters. In Outlook 2007 and Outlook 2010, this folder is called Content.Outlook and then has a subfolder which is named with with 8 random numbers and letters. In addition, by default, you cannot simply browse to the folder to clean it out. Getting to the Temporary Outlook Folder can still be accomplished in 2 easy steps though.
Step 1: Locate the folder
The folder location is stored in the registry in the following key;

Outlook 97	HKEY_CURRENT_USER\Software\Microsoft\Office\8.0\Outlook\Security
Outlook 98	HKEY_CURRENT_USER\Software\Microsoft\Office\8.5\Outlook\Security
Outlook 2000	HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Outlook\Security
Outlook 2002/XP	HKEY_CURRENT_USER\Software\Microsoft\Office\10.0\Outlook\Security
Outlook 2003	HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook\Security
Outlook 2007	HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Outlook\Security
Outlook 2010	HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Outlook\Security

Step 2: Get to the folder

1. Open the OutlookSecureTempFolder registry key from the location provided in Step 1.
2. Copy the path from the key.
3. Open Explorer
4. Paste the address in the Address Bar and press Enter

Use OutlookTools or OutlookTempCleaner

Still not easy enough or just don’t want to go in the Registry to find the folder location? I’ve created two free tools which can do the trick as well.
OutlookTools offers besides locating, opening and cleaning up the SecureTempFolder also quite a lot of additional features to troubleshoot and tweak Outlook.
OutlookTempCleaner focuses only on dealing with the SecureTempFolder and can also be used in (corporate) login and logoff scripts to clean up the folder without any end-user interaction.

OutlookTempCleaner can detect and empty Outlook’s Secure Temp folder automatically for you.

Last modified: September 30, 2010