Looking for SKU001.CAB?
When doing a number of things with Microsoft Office such as reinstalling it, repairing it, installing SP3, etc the error SKU001.CAB is missing may appear looking for a CD or other installation files.
It seems that even if you have the Microsoft Office files on your hard drive or if you insert your original CD that it still can’t find this cab file.
This error may also occur when simply launching any of the applications in Microsoft Office such as Word, Excel or Powerpoint particularaly after an crash or a previous update was applied which is very annoying indeed.
- When re-installing, repairing, upgrading or just launching an application from the Microsoft Office suite the error “SKU001.CAB is missing” appears.
This error is occurring because a registry entry is incorrectly set and setup is looking in the wrong place.
Solution – Change CDCACHE Registry Entry
- If you still have the error message on your screen then close down all open windows including the error so that you have no programs running.
- Click Start > Run
- Type regedit and hit ENTER or click OK
- You should see the navigation tree in the left pane. Navigate to the following keys:
- Inside the Delivery Key there should be one more key which is a long string of numbers for example:
- Click on the key and then you should see some entries in the right hand pane.
- Double click on the entry CDCache
- Change the value to 0
Depending on your version of Microsoft Office the registry path may be different.
The above path and delivery key is only examples.
Yours will look similar but not necessarily identical. The important entry to find is the CDCACHE entry.
- Click OK and then exit the Registry and retry the MS Office installation.
This download is a Microsoft Excel workbook containing sample Visual Basic for Applications (VBA) code that was mentioned in the article:
HOWTO: Excel – Detect an Empty Cell.
This download is provided free and without any guarantee that it will solve your problems. You may however use it as you wish and distribute it freely to your friends and colleagues if it’s of some use.
If it is useful, it would be nice if you would link back to this site, leave a comment, follow us on twitter or just say Hi.
Check For An Empty Cell in Microsoft Excel
This HOWTO explains how you can detect an empty cell and provide an error message if the cell is empty in a Microsoft Excel worksheet.
It should work for all versions of Excel.
The cell we are checking for an empty value will be checked every time a user makes a change to the cell.
Download a sample excel file here
In this example, that cell will be cell C5.
Use Microsoft Excel’s VBA to detect the empty cell
- Open the worksheet you want to detect the empty cell in.
- Take a note of the cell you want to check for an empty value. e.g. C5 in this example
- Open the the Visual Basic Editor by clicking Tools > Macro > Visual Basic Editor or press ALT+F11 on the keyboard
- On the left pane, right click the sheet that contains the cell you want to check and click ‘View Code‘
- On the right pane, enter or copy/paste the following code:
Private Sub Worksheet_Change(ByVal Target As Range)
If IsEmpty(Cells(5, 3)) Then MsgBox (“Empty Cell – Please ensure there is a value in all grey cells. Thanks”)
- The above code will check cell C3 on my worksheet which is highlighted in grey in the screen shot below.
- Change the your code as follows:
- Enter your cell number in place of the Cells(5,3) reference.
- For example, Cells(5,3) = Cell C3. The 5 is the row number and the 3 is the column number.
- For MsgBox, enter your own custom message between the quotes.
- Close the Visual Basic Editor by clicking the X in the top right corner of the window
- Test your worksheet. It should look like the below screenshot after you attempt to clear the value from cell C3.