Category Archives: MS Office

Microsoft Excel cannot open or save any more documents because there is not enough available memory or disk space

Applies to Windows 8, Windows 8.1

Run the Windows Firewall Service

  • Open Services (services.msc) from Control Panel – Administrative Tools – Services
  • Locate the Windows Firewall Service
  • Double-click the Windows Firewall Service and from the General Tab change the Startup Type selection to Automatic
  • Restart the System
  • Upon restart check the status of the Windows Firewall Service. If it is in running mode, you may try opening the excel file
  • If the Windows Firewall is still not in running mode; you will need to make changes to the registry

Changes to Registry

  • Open Registry Editor (regedit)
  • Navigate to: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control
  • With the control folder selected, right click in the pane on the right and select new DWORD Value
  • Name the new DWORD -ServicesPipeTimeout
  • Right-click ServicesPipeTimeout, and then click Modify
  • Click Decimal, type ‘180000’, and then click OK
  • Restart the computer and check the Windows Firewall Service once again
  • If the service has started; you may open the excel files without any error

If the Windows Firewall service has still not started working after the above instructions, I would advice looking for further assistance. But we do have a temporary workaround to enable opening of individual excel files

Temporary Workaround

  • Right-Click the specific Excel File and click Properties
  • In the General Click Unblock under Security
  • The file should now open without any error
Advertisements

Convert HWP file to Word format

HWP is a Korean Word processor file format. There is a simple tool that will help you view these attachments in word

HWP Document Convertor for Microsoft Word (Works with Office 2007 and above)

Download Link

  • Run the Installation File
  • Use MS Word to open the HWP file and you are done!

Excel – Calculate the number of days in a month

Use below formula to extract the number of days for a specific month

=DAY(DATE(theyear,themonth+1,1)-1)

For Example; suppose you require to display number of days for the month of Feb 2014

=DAY(DATE(2014,2+1,1)-1)

This equals 28

Excel Password Removal – Excel 2007 / Excel 2010

There are several instances when we would have protected entire Excel Workbooks or specific Worksheets and then totally forgotten about it.  An online search will fetch a thousand options for password removal.

The one on this blog is simple, straight-forward and no software requires to be download. All we need is a simple BASE Script

This has tried and tested on Excel 2007 and 2010 versions

  1. Download the Script file from this link (ScriptFile)
  2. Open the Password Protected Excel File
  3. Press ALT+F11 on your keyboard; the Visual Basic Editor opens
  4. From the File Menu; click Import and select the BASE Script file () that you downloaded earlier
  5. From the File Menu; click Close and Return to Microsoft Excel
  6. From the View Tab in Excel;  Click View Macros (Illustration provided below)
  7. Select Macro1 and Click Run (Illustration provided below)
  8. The password removal utility that opens will guide you through the rest

ViewMacros

ExcelMacro

 

 

Difference between VLOOKUP and INDEX-MATCH Formulas in Excel

Below is a Video Illustration in Excel 2010. It applies to Excel 2007 and above