The 1402 Office error is a problem that's caused when you try and install the Office package of applications to your computer. It's specifically caused by your computer's inability to access a certain "registry key" on your system, preventing it from being able to install the files & settings that are required.
This error will normally appear in this format:
Error 1402. Could Not Open Key
The specifics of this error are quite precise - in that it will be caused by your computer's inability to place certain settings into the registry of your system. The registry is a huge database that Windows uses to store vital files & settings for your PC, and is where everything from your desktop shortcuts to your software's options are stored. Because Office is such a complicated program, it has many registry keys it need to insert into this database… and the 1402 shows that this cannot be done.
There are generally two reasons why the 1402 error will show - the first is that you're trying to install the Microsoft Office software onto a PC that doesn't have a registry database (versions of Windows prior to '98 don't have a registry), and the second reason is that your user account does not have the correct privileges to install programs on your system.
The way to fix this problem is to initially ensure that your computer is able to actually install a program like this - if you have Windows 98 or below, then you really need to upgrade your system before attempting to install the likes of Microsoft Office. If you have a compatible version of Windows, then you need to look at changing / updating your user profile to ensure that you have enough permission to install the programs / files / settings that you need on your PC. It's also recommended that you clean out the "registry" of your system with a registry cleaner - which should remove any potentially conflicting files / programs from your system.
Open Office () is open source software, collaboratively developed by people from all over the world. The Microsoft Office Suite (MsOffice), on the other hand, was solely developed by the Microsoft Corporation. They have pretty much the same content - a word processor, a spreadsheet application, a presentation maker, etc. However, they have some major differences that makes them unique from each other.
First - Open Office is cheaper than MsOffice. The cheapest MsOffice package starts at USD 149.99 while Open Office is absolutely free. A hundred and fifty dollars may not hurt a lot, but this becomes a considerable pain in the neck when a large company has a lot of computers to install it to, as the each MsOffice package can be installed on just one computer, as required by law.
Many universities across the world have shifted to OpenOffice because of this. The University of Melbourne and the US State of Maine are just two of them. Various private companies have also adopted them, such as Sumitomo of Japan, and also government offices, like the City Government of Berlin, Germany.
However, some institutions still prefer MsOffice due to its popularity and familiarity. Some features of OpenOffice work in a very odd and unintuitive way. For example, putting page numbers on text files in OpenOffice Writer can be one heck of a challenge, while it takes only a couple of seconds in Ms Word.
Second - OpenOffice has everything in it, unlike some MS Office Packages. All of the features of OpenOffice are already there - it has an equation editor, an HTML editor, everything. On the other hard, the basic MsOffice package, MsOffice Student Edition at USD 149.99, only has Excel (spreadsheet), Word (word processor) and PowerPoint (presentation maker), while everything else is a la carte. A full MsOffice package can cost as much as USD 499.99 - the same price for a mid-end laptop.
However, MsOffice gives more comprehensive technical support than its competitor. MsOffice offers phone-based support, something that is very important for someone who needs accurate answers fast. OpenOffice on the other hand, offers only forum-based support, which can be problematic especially when you do not know the name for the feature that you are having a problem about.
In light of the recent developments of Microsoft's Ad-supported Office Starter 2010, I think it's quite appropriate for people to start looking for an alternative works software. Personally, I think this is a double edged sword for Microsoft. The good part is that their office software will be available to more people for free, but then the downside is that you'll be annoyed by ads flashing on your screen. It might not appear that bad, who knows? 2010 is still months away and we don't know what can change in the next few months, but as it stands, this doesn't seem like something to suffer.
For another thing you don't just suffer ads while you're working on an imortant document or presentation, but you'll have to suffer a lack of functionality that is common with all the other free teasers that want you to buy the whole thing.
So what is Open Office and why is it more beneficial? Long story short, Open Office offers the same functionality as Microsoft Office, except it's totally free software and you don't need to suffer ads while you're working on it. Why wasn't this popular a long time ago? The same reason why Linux isn't mainstream; Apple and Microsoft have dominated the mainstream of operating systems forever.
Linux is merely an alternative for those who can deal with not being able to have the software that they're used to on those operating systems. Anyway, back to Open Office.
You can write anything on Open Office these days and it can read any kind of text document, well actually, it really just has a wide range of documents that it's able to read. It can read any document that's been saved on Microsoft Word if that's what you're concerned about. It can also run on any operating system: Linux operating systems are a given, it can run from OS X Jaguar to Snow Leopard and from Windows XP to Windows Vista.
Like I said it's free software that's pretty competent so it's worth for that reason at least. Download Open Office from their main site and you can try it out for your self but I need to warn you, that the feel of writing on it will be different from what you're used to on a Mac or PC. Sure, typing will be no different, it'll have familiar functionality, the only difference is how you go about doing those tasks. Shortcuts will be different and you might find that there are certain functions that might be missing.
I haven't gone about exploring the missing functionality myself, but Open Office seems to work fine just for me. But that's another great thing about Open Office. Whenever you have a problem, you can always. They give quick response to a problem and see that it gets fixed.
Every time you go over to someone else's house or even go to work you always seem to come across Microsoft Office 2003 and if you are like me you probably wonder why they don't make the upgrade to 2007. It's possible that they are afraid of the differences or even more likely the price!
Some of the featured changes in Office 2007 are the User Interface Ribbon, the menu bar, and the quick access tool bar. In office 2007 they did away with the standard drop down boxes click and click functionality. At the top there are seven categories; click on these to access the most used functions in previous versions of the software. They placed all of these functions in a user friendly graphical interface.
Most people are also used to the menu bar at the top containing all of the functions in the software that can also be found in the old GUI, they did away with this outdated feature and added an Office logo in the top left corner which contains most of the functions found in the file menu. Just to the right of this menu are the a few of the most commonly used functions, like save and print. One of my personal favorite features is the quick access tool bar that appears when you right click, for example in Word 2007 it contains the most used functions right at your mouse tip for easy access like Bold, Italics, and Underline.
If the new easy to use features are not enough to get you to switch or upgrade to Office 2007, then what is holding you back?
Office 2007 is not a huge system hog, the minimum system requirements are normal Pentium III PC with Windows XP SP 2, Server 2003 SP1, or Vista; at least 256 MB RAM and 2 GB hard drive space can be use to install Office 2007. If you already purchased Office 2003 then it's obvious you're already used to playing way too much for an Office suite software package. Office 2007 also offers eight different packages for you to choose from, these included Microsoft Office Enterprise, Professional Plus, Ultimate, Professional, Small Business, Standard, Home & Student and Basic 2007.
However, if you just are not a believer that $675.95 is worth it for a few office programs then visit my blog to find out more about the specific changes to Office 2007, what the packages include and how to get yourself a copy of Microsoft Office 2007 completely free, thats right obtain a working copy at absolutely no cost to you.
Microsoft Excel 2007 Tutorial - Workbook Security
Microsoft Office Excel 2007 provides many ways to secure and protect your work. For optimal security, you should protect your entire workbook file with a strong password. Excel passwords can be up to 255 letters, numbers, spaces, and symbols and are CaSe SeNsItIvE. For additional protection of data inside your workbook, you can protect specific worksheet or workbook elements, with or without a password. Protecting worksheet or workbook elements may help prevent users from accidentally or deliberately changing, moving, or deleting important data.
In this Microsoft Excel 2007 Tutorial, I'll show you how to create a password to protect your workbook and how to protect some workbook elements. There are many Excel Tips and Tricks to guide to being an expert Excel user. I have other Excel Tips as part of my Microsoft Excel 2007 Tutorial series that I hope you find useful.
To provide security to your entire workbook, you can specify two separate passwords:
Open and view the workbook. This is an encrypted password that prevents unauthorized access to your workbook. You can also give users the option to open in read-only mode if they are just viewing data. This can help prevent accidental changes from being saved.Modify the workbook. This is an unencrypted password that is only meant to give specific users permission to edit the workbook.
These passwords apply to the entire workbook and they don't have to be the same password. In fact, it is much safer to use different passwords. To provide strong security, you may want to utilize both features. Speaking of strong, strong passwords combine uppercase and lowercase letters, numbers, and symbols. sweetheartone is not strong, but Sw33tH3ArT0nE is strong.
To secure your workbook with a password:
Click the Microsoft Office Button, then click Save As, then choose Excel Workbook. Yes, do this for an existing workbook.On the bottom left of the Save As dialog box, click the Tools button and choose General Options.To require users to enter a password upon opening the file, type a password in the Password to open box.To require users to enter a password that allows them to make and save changes, type a password in the Password to modify box.To protect from users accidentally modifying the file, select the Read-only recommended check box. Users will be asked whether or not they want to open the file as read-only. NOTE! If you created a Password to modify, the user, when prompted to enter this password, will have the option to open as read-only. Therefore, this option is not necessary when using Password to modify.Click OK.You'll be prompted to retype your passwords to confirm them. Click OK after confirming.Click the Save button.If this is an existing workbook and you're using the same file-name, you'll be prompted to click Yes to replace the existing workbook.
Microsoft Office Excel 2007 provides options to protect your data from being changed or deleted by using worksheet element security and workbook element security. For other Microsoft Office Excel Tips and Tricks, see my other articles in the Microsoft Excel 2007 Tutorials series.
WORKSHEET ELEMENT SECURITY
On the worksheet that you want to protect, unlock any cells or ranges that you want other users to be able to change:Select each cell that you want to unlock or select a whole range of cells.On the Home tab, in the Cells group, click the Format button, then click Format Cells.On the Protection tab, clear the Locked check box.You can hide formulas that you don't want users to see:Select the cells that contain the formulas you want to hide.On the Home tab, in the Cells group, click Format, then click Format Cells.On the Protection tab, select the Hidden check box, then click OK.If you want to unlock objects like pictures, clip art, or shapes do the following:Hold down [CTRL] while clicking each object that you want to unlock. The Picture Tools or Drawing Tools will be displayed, adding a Format tab. NOTE! Don't select objects of different types as the Dialog Box Launcher won't the Format tab, in the Size group, click the Dialog Box Launcher next to Size.On the Properties tab, clear the Locked check box. If present, clear the Lock text check box.Click the Close button.On the Review tab, in the Changes group, click Protect Sheet.In the Allow all users of this worksheet to list, select the elements that you want to allow users to change.In the Password to unprotect sheet box, type a password for the sheet, click OK, then confirm the password. This is an optional password. If you don't use it, then any user can unprotect the sheet and change the protected elements.
WORKBOOK ELEMENT SECURITY
You use workbook element security to prevent users from, among others:
Viewing worksheets that you have hiddenMoving, deleting, hiding, or changing the names of worksheetsInserting new worksheets or chart sheetsMoving or copying worksheets to another workbookIn PivotTable reports, displaying the source data for a cell in the data area, or displaying page field pages on separate worksheetsRecording new macros
On the Review tab, in the Changes group, click Protect Workbook and select the Protect Structure and Windows option.To protect the structure of a workbook, select the Structure check box.To keep workbook windows in the same size and position each time the workbook is opened, select the Windows check box.To prevent users from removing this workbook protection, in the Password (optional) box, type a password, click OK, then confirm it. This is an optional password. If you don't supply a password, then any user can unprotect the workbook and change the protected elements.
Excel security is an important feature that can help protect your data.
I cannot possibly tell you in the scope of this article many things a person can do with Microsoft Excel. It is used in homes, schools Kindergarten through college, and a variety of small businesses by thousands of people. Knowledge of office applications is a need in almost every place a prospective employer is hiring for. The salary a person receives depends on their level of ability. So the question is what do you want to learn about Microsoft Excel? There are some very practical ways to approach your goal of learning Microsoft Excel.
The first step is to figure out just how much you need to know based on what your needs are. The knowledge is out there to help you with a home project, job promotion or how to go all the way to Microsoft Excel Certification.
There is a surplus of ideas that come to mind for learning Microsoft Excel. The first place to start would be at your favorite book store. When you are shopping for your book it is wise to look at the contents first. If you are reading this article you are most likely a beginner; a good starting point would be to explore the excel window, learn a few keywords, and how to navigate a worksheet. Two things to consider are: if topics are within your level of expertise, and are structured for the beginner.
Most community colleges offer classes in office applications that are either credit or non-credit classes. Most local library's have free computer classes. If you are the type of learner who needs someone to coach you along the way these are good choices for you.
If you are the more adventurous type and self-motivated Microsoft's web site offers help and how to video courses that take you through step by step tutorials you can also link to information about Microsoft Certification. The web site's navigation is very easy so finding the video courses is a relatively easy try.
There are easy to read icons at the top of the page and you can just click on the office application of your choice to gain access to the free instructions. Be aware though that the video courses only cover Microsoft Office 2010. If you have an older version of Microsoft Office on your computer you may find some instructions by reading the links to find older versions or use the search bar to type in your version of Microsoft Office. For written instruction check the library, thrift stores, eBay, yard sales, and bookstores that carry older books. Just have fun with it and remember nothing you do on your computer is Permanent so if you mess up just start over.
So decide what your level of expertise is and what you want it to be. Figuring out where to start is the most difficult step in any project. You won't be so overwhelmed by all the information out there if you already know what you are looking for. Then have some fun with an inventory, such as a collection or if you are working out a family budget then use the formatting to make it have a visually pleasing look.
by Dorolis Day-Morris