In Microsoft Excel, when you perform a mathematical operation on cells that contain text and values, you may receive a #VALUE! error. In this post i will given some idea for Microsoft Excel Support to slove that type of problems.
Although some functions correctly evaluate cells and ignore text strings, if you add the cells by using arithmetic operators such as addition (+), subtraction (-), multiplication (*), or division (/), an error value may occur.
Do the following for Resolution
Instead of using an individual mathematical operator, use its equivalent worksheet function instead:
SUM (adds)
PRODUCT (multiplies)
QUOTIENT (divides)
For example, if you type the following information in cells A1:A7 of a worksheet
A1: 10
A2: text
A3: 20
A4: =A1+A2+A3
A5: =SUM(A1+A2+A3)
A6: =SUM(A1,A2,A3)
A7: =SUM(A1:A3)
the formulas in cells A4 and A5 return a #VALUE! error; however, cells A6 and A7 return the correct value of 30.
Showing posts with label Microsoft Office Support. Show all posts
Showing posts with label Microsoft Office Support. Show all posts
Wednesday, November 12, 2008
Tuesday, November 4, 2008
New Field button is unavailable in Show Field dialog boxes in Outlook
When you use the Field Chooser or Show Fields options in Microsoft Outlook, the resulting dialog boxes may display the New Field button as dimmed (unavailable), or if available, when you click the New Field button, you may receive the following message:
You do not have permission to add a custom field to the folder. Any field you create will appear only in the current view.
To fix this Outlook problem we have to care on You can only create MAPI folder to which you have sufficient privileges.
How to Access Show Field Option
To access the Show Fields option, on the View menu, point to Current View, point to Customize Current View, and then click Fields.
Note In Outlook 2003, on the View menu, point to Arrange By, point to Current View, click Customize Current View, and then click Fields.
The New Field button is not available for one of the following reasons:
- The current folder is a file system folder. For example, if the folder banner shows that the active folder is My Documents, then the New Field button will be unavailable.
- You do not have sufficient permissions to the selected MAPI folder. If the current folder is a MAPI folder, such as a public folder, you must have sufficient permissions to that folder to allow the creation of fields. Have the folder owner ensure create permission is available to you for the active folder. The folder owner, or another user with sufficient permissions, can access the permission settings for the folder by right-clicking the folder in the Outlook Bar or Folder List, and then clicking Properties on the shortcut menu.
To validate that the New Field button is working properly, follow these steps:
1. Select the Inbox or another MAPI folder to which you know you have sufficient permissions.
2. Right-click a column header and click Field Chooser on the shortcut menu.
3. Confirm that the New Field button is available by clicking the button
You do not have permission to add a custom field to the folder. Any field you create will appear only in the current view.
To fix this Outlook problem we have to care on You can only create MAPI folder to which you have sufficient privileges.
How to Access Show Field Option
To access the Show Fields option, on the View menu, point to Current View, point to Customize Current View, and then click Fields.
Note In Outlook 2003, on the View menu, point to Arrange By, point to Current View, click Customize Current View, and then click Fields.
The New Field button is not available for one of the following reasons:
- The current folder is a file system folder. For example, if the folder banner shows that the active folder is My Documents, then the New Field button will be unavailable.
- You do not have sufficient permissions to the selected MAPI folder. If the current folder is a MAPI folder, such as a public folder, you must have sufficient permissions to that folder to allow the creation of fields. Have the folder owner ensure create permission is available to you for the active folder. The folder owner, or another user with sufficient permissions, can access the permission settings for the folder by right-clicking the folder in the Outlook Bar or Folder List, and then clicking Properties on the shortcut menu.
To validate that the New Field button is working properly, follow these steps:
1. Select the Inbox or another MAPI folder to which you know you have sufficient permissions.
2. Right-click a column header and click Field Chooser on the shortcut menu.
3. Confirm that the New Field button is available by clicking the button
Wednesday, October 29, 2008
Subscript characters are displayed incorrectly when you insert them in Excel 2003 or in Excel 2002
SYMPTOMS
When you insert subscript characters in Microsoft Office Excel 2003 or in Microsoft Excel 2002, the characters are displayed incorrectly. For example, an empty rectangle is displayed when you insert subscript one.
CAUSE
When you insert subscript characters, Excel 2003 and Excel 2002 use the Arial Unicode MS font if one of the following is not installed on the computer:
• An appropriate font, such as MS MIncho or MS Gothic
• Support files for the East Asian languages
The Arial Unicode MS font cannot resolve all characters correctly.
WORKAROUND
To work around this issue, use one of the following methods:
Method 1
Install the MS MIncho font or the MS Gothic font on the computer. To do this, follow these steps:
1. Click Start, click Run, type Fonts, and then click OK.
2. Click Install New Font in the File menu.
3. In the Add Fonts dialog box, locate the font file for the MS MIncho font or for the MS Gothic font, and then click OK.
Method 2
Install the East Asian languages support files. To do this, follow these steps:
1. Click Start, click Run, type Intl.cpl, and then click OK.
2. Click the Languages tab, click the Install files for East Asian languages check box, and then click OK.
APPLIES TO
• Microsoft Office Excel 2003
• Microsoft Excel 2002 Standard Edition
source spport.microsoft.com
When you insert subscript characters in Microsoft Office Excel 2003 or in Microsoft Excel 2002, the characters are displayed incorrectly. For example, an empty rectangle is displayed when you insert subscript one.
CAUSE
When you insert subscript characters, Excel 2003 and Excel 2002 use the Arial Unicode MS font if one of the following is not installed on the computer:
• An appropriate font, such as MS MIncho or MS Gothic
• Support files for the East Asian languages
The Arial Unicode MS font cannot resolve all characters correctly.
WORKAROUND
To work around this issue, use one of the following methods:
Method 1
Install the MS MIncho font or the MS Gothic font on the computer. To do this, follow these steps:
1. Click Start, click Run, type Fonts, and then click OK.
2. Click Install New Font in the File menu.
3. In the Add Fonts dialog box, locate the font file for the MS MIncho font or for the MS Gothic font, and then click OK.
Method 2
Install the East Asian languages support files. To do this, follow these steps:
1. Click Start, click Run, type Intl.cpl, and then click OK.
2. Click the Languages tab, click the Install files for East Asian languages check box, and then click OK.
APPLIES TO
• Microsoft Office Excel 2003
• Microsoft Excel 2002 Standard Edition
source spport.microsoft.com
Tuesday, October 21, 2008
Error message when you try to import or to export files in Outlook: "Microsoft Outlook cannot start the required translator"
SYMPTOMS
When you try to import or to export files in Microsoft Office Outlook 2003, you receive the following message:
Microsoft Office Outlook cannot start the required translator. This feature is not currently installed. Would you like to install it now?
Additionally, when you insert the Outlook 2003 CD-ROM or the Office 2003 CD-ROM, you may receive the following error message:
Error 1311. Source file not found C:/MSOCACHE/All Users
When you try to import or to export files in the 2007 Microsoft Office system, you may receive one of the following error messages:
Error 1334. The file '.SAM_1033' cannot be installed because the file cannot be found in cabinet file 'OutlkLR.CAB'. This could indicate a network error, an error reading from the CD-ROM, or a problem with this package.
The file ‘C:\MSOCache\All Users\{}\’ is not a valid installation package for the product () 2007. Try to find the installation package ‘OutlookMUI.msi’ in a folder from which you can install MUI () 2007.
Error 1706. Setup cannot find the required files. Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:\DOCUME~1\\LOCALS~1\Temp\Setup0000043c\SETUP.CHM.
CAUSE
This issue occurs if certain translator files or certain database converters are not available because they were not installed during Setup. Converters in Outlook are installed on demand. Additionally, the local install source folder (Msocache) may be damaged or missing.
This issue also applies to third-party personal information management (PIM) files and to file types that use Open Database Connectivity (ODBC).
RESOLUTION
To resolve this issue, use one of the following methods, as appropriate for the version of Outlook that you are running.
Outlook 2003
Click Yes when you receive the message that is mentioned in the "Symptoms" section of this article. After you click Yes, Microsoft Windows Installer starts and then installs the database converters and translator files for the file that you want to import or to export.
If this resolution does not resolve the issue, run the Microsoft Office Setup program and install the filters directly. To do this, follow these steps:
1. Exit Outlook 2003.
2. Remove the Msocache folder. For more information about how to remove the Msocache folder, click the following article number to view the article in the Microsoft Knowledge Base:
825933 Local Install Source (Msocache)
3. Click Start, and then click Control Panel.
4. Click Add or Remove Programs.
5. In the Currently installed programs list, click Microsoft Office 2003, and then click Change.
6. In the Microsoft Office 2003 Setup dialog box, click Add or Remove Features under the Maintenance Mode Options area, and then click Next.
7. Under the Custom Setup area, click to select the Choose advanced customization of applications check box, and then click Next.
8. Under the Choose update options for applications and tools area, expand Microsoft Office Outlook.
9. Click the down arrow next to Importers and Exporters, and then click either the Run from My Computer option or the Run all from My Computer option.
10. In the Microsoft Office 2003 Setup dialog box, click Update.
Microsoft Office Outlook 2007
Insert the CD or DVD media when you are prompted. If you installed Outlook 2007 from a network share, make sure that the share is accessible from your workstation.
After you provide the setup files, the setup process will complete successfully. Additionally, any missing or corrupted files in the \MSOCache folder will be replaced.
If the same error occurs in the future, delete the \MSOCache folder, and then run the Online Microsoft Outlook setup 2007 process again. When run Setup again, make sure that you select the Repair option in the Change your installation window.
MORE INFORMATION
PIM formats
The following PIM program data files can be imported to Outlook 2007:
• Microsoft Excel
• Microsoft Access
• Comma Separated Values (CSV) Windows
• Comma Separated Values (CSV) DOS
• Tab Separated Values (TSV) Windows
• Tab Separated Values (TSV) DOS
• ACT! 3.x, ACT! 4.0, and ACT! 2000
• Organizer 4.x and Organizer 5.x
• Personal Address Book
The following PIM program data files can be imported to Outlook 2003:
• Microsoft Excel
• Microsoft Access
• Comma Separated Values (CSV) Windows
• Comma Separated Values (CSV) DOS
• Tab Separated Values (TSV) Windows
• Tab Separated Values (TSV) DOS
• Schedule + 7.x and Schedule + SC2 ACT! 3.x,
• ACT! 3.x, ACT! 4.0, and ACT! 2000
• Organizer 4.x and Organizer 5.x
• Personal Address Book
The following PIM formats can be exported from Outlook 2007 and from Outlook 2003:
• Microsoft Excel
• Microsoft Access
• Comma Separated Values (CSV) Windows
• Comma Separated Values (CSV) DOS
• Tab Separated Values (TSV) Windows
• Tab Separated Values (TSV) DOS
Note: Click For Online Email Support
External link: http://support.microsoft.com/kb/829985/en-us?spid=2520&sid=312
When you try to import or to export files in Microsoft Office Outlook 2003, you receive the following message:
Microsoft Office Outlook cannot start the required translator. This feature is not currently installed. Would you like to install it now?
Additionally, when you insert the Outlook 2003 CD-ROM or the Office 2003 CD-ROM, you may receive the following error message:
Error 1311. Source file not found C:/MSOCACHE/All Users
When you try to import or to export files in the 2007 Microsoft Office system, you may receive one of the following error messages:
Error 1334. The file '
The file ‘C:\MSOCache\All Users\{
Error 1706. Setup cannot find the required files. Check your connection to the network, or CD-ROM drive. For other potential solutions to this problem, see C:\DOCUME~1\
CAUSE
This issue occurs if certain translator files or certain database converters are not available because they were not installed during Setup. Converters in Outlook are installed on demand. Additionally, the local install source folder (Msocache) may be damaged or missing.
This issue also applies to third-party personal information management (PIM) files and to file types that use Open Database Connectivity (ODBC).
RESOLUTION
To resolve this issue, use one of the following methods, as appropriate for the version of Outlook that you are running.
Outlook 2003
Click Yes when you receive the message that is mentioned in the "Symptoms" section of this article. After you click Yes, Microsoft Windows Installer starts and then installs the database converters and translator files for the file that you want to import or to export.
If this resolution does not resolve the issue, run the Microsoft Office Setup program and install the filters directly. To do this, follow these steps:
1. Exit Outlook 2003.
2. Remove the Msocache folder. For more information about how to remove the Msocache folder, click the following article number to view the article in the Microsoft Knowledge Base:
825933 Local Install Source (Msocache)
3. Click Start, and then click Control Panel.
4. Click Add or Remove Programs.
5. In the Currently installed programs list, click Microsoft Office 2003, and then click Change.
6. In the Microsoft Office 2003 Setup dialog box, click Add or Remove Features under the Maintenance Mode Options area, and then click Next.
7. Under the Custom Setup area, click to select the Choose advanced customization of applications check box, and then click Next.
8. Under the Choose update options for applications and tools area, expand Microsoft Office Outlook.
9. Click the down arrow next to Importers and Exporters, and then click either the Run from My Computer option or the Run all from My Computer option.
10. In the Microsoft Office 2003 Setup dialog box, click Update.
Microsoft Office Outlook 2007
Insert the CD or DVD media when you are prompted. If you installed Outlook 2007 from a network share, make sure that the share is accessible from your workstation.
After you provide the setup files, the setup process will complete successfully. Additionally, any missing or corrupted files in the \MSOCache folder will be replaced.
If the same error occurs in the future, delete the \MSOCache folder, and then run the Online Microsoft Outlook setup 2007 process again. When run Setup again, make sure that you select the Repair option in the Change your installation window.
MORE INFORMATION
PIM formats
The following PIM program data files can be imported to Outlook 2007:
• Microsoft Excel
• Microsoft Access
• Comma Separated Values (CSV) Windows
• Comma Separated Values (CSV) DOS
• Tab Separated Values (TSV) Windows
• Tab Separated Values (TSV) DOS
• ACT! 3.x, ACT! 4.0, and ACT! 2000
• Organizer 4.x and Organizer 5.x
• Personal Address Book
The following PIM program data files can be imported to Outlook 2003:
• Microsoft Excel
• Microsoft Access
• Comma Separated Values (CSV) Windows
• Comma Separated Values (CSV) DOS
• Tab Separated Values (TSV) Windows
• Tab Separated Values (TSV) DOS
• Schedule + 7.x and Schedule + SC2 ACT! 3.x,
• ACT! 3.x, ACT! 4.0, and ACT! 2000
• Organizer 4.x and Organizer 5.x
• Personal Address Book
The following PIM formats can be exported from Outlook 2007 and from Outlook 2003:
• Microsoft Excel
• Microsoft Access
• Comma Separated Values (CSV) Windows
• Comma Separated Values (CSV) DOS
• Tab Separated Values (TSV) Windows
• Tab Separated Values (TSV) DOS
Note: Click For Online Email Support
External link: http://support.microsoft.com/kb/829985/en-us?spid=2520&sid=312
Monday, October 13, 2008
mail Word 2007 Document For Reviews and Tracking Changes
Emailing a Word 2007 document to another user for review, meaning any changes they make it will track those changes in Word 2007, is a snap!
Getting it setup takes a few more steps than previous version of Word 2000, Word XP (2002) and Word 2003. Because in those versions it was a simple: File>Send To>Mail Recipient (For Review), and then click the Send (b) to email it off.
Stop bloviating and tell me where to do the same with Word 2007 you opine! Fine. But let me warn you that writing more than steps is not only therapeutic for me when it comes to blogging, but downright fun!
Email Word 2007 Document For Review and Tracking Changes Steps. First you have to add the Send For Review (b) to you QAT (Quick Access Toolbar). Yeah! I know there’s not another easier way I know of. So Right /QAT toolbar>Customize, /Choose commands arrow>All, scroll to & //Send for Review, /ok. Now on your QAT toolbar /Send for Review (b) and it will do two things: first attach your Word 2007 document into an email, and also it turns on the Track Changes (b) on the Review tab. Now just type in an email address and /Send (b) to email your document off to one of your Super Friends!
Once Wonder Woman (one of your Super Friends) opens the attachment and makes any changes to the document, it will track it i.e. if she deletes a word it will put a red line through it, and if she adds text it will color it in green. So when she’s done all she has to do email those changes back to you where you can, with the help of Reviewing tab, accept or reject her changes i.e. removing the red lines for deletions, or removing her added text.
You know you can just as easily open Word 2007, /Review tab & /the Track Changes (b) and turn on the changes yourself and the /Word’s Office Logo (b)>Send and email without having to add the Send For Review (b) to your QAT toolbar.
Having said that I bet you’re thinking: I wouldn’t choose Wonder Woman as a Super Friend with only a magic lasso to protect me, and second anybody can turn off the “Track Changes” feature and then I couldn’t protect my document from unwanted, trackable changes!
Yes, you’re right and so the only way to “protect” someone from messing with your document without being trackable, or seeing their changes is to follow these steps: /Developer tab>Protect group & /Protect Document (b)>Restrict Formatting and Editing, in Task Pane’s Editing restrictions section check “Allow only this…” box and /its arrow>Tracked changes & /Yes, Start Enforcing Protection (b) and type in your password.
Now that’s protection! Okay, having password protection on a document is like having a Super Friend like Superman protecting you. Invincible he is until some krptonite is found - iyogi computer help services breaks the password, but better than nothing eh?
Getting it setup takes a few more steps than previous version of Word 2000, Word XP (2002) and Word 2003. Because in those versions it was a simple: File>Send To>Mail Recipient (For Review), and then click the Send (b) to email it off.
Stop bloviating and tell me where to do the same with Word 2007 you opine! Fine. But let me warn you that writing more than steps is not only therapeutic for me when it comes to blogging, but downright fun!
Email Word 2007 Document For Review and Tracking Changes Steps. First you have to add the Send For Review (b) to you QAT (Quick Access Toolbar). Yeah! I know there’s not another easier way I know of. So Right /QAT toolbar>Customize, /Choose commands arrow>All, scroll to & //Send for Review, /ok. Now on your QAT toolbar /Send for Review (b) and it will do two things: first attach your Word 2007 document into an email, and also it turns on the Track Changes (b) on the Review tab. Now just type in an email address and /Send (b) to email your document off to one of your Super Friends!
Once Wonder Woman (one of your Super Friends) opens the attachment and makes any changes to the document, it will track it i.e. if she deletes a word it will put a red line through it, and if she adds text it will color it in green. So when she’s done all she has to do email those changes back to you where you can, with the help of Reviewing tab, accept or reject her changes i.e. removing the red lines for deletions, or removing her added text.
You know you can just as easily open Word 2007, /Review tab & /the Track Changes (b) and turn on the changes yourself and the /Word’s Office Logo (b)>Send and email without having to add the Send For Review (b) to your QAT toolbar.
Having said that I bet you’re thinking: I wouldn’t choose Wonder Woman as a Super Friend with only a magic lasso to protect me, and second anybody can turn off the “Track Changes” feature and then I couldn’t protect my document from unwanted, trackable changes!
Yes, you’re right and so the only way to “protect” someone from messing with your document without being trackable, or seeing their changes is to follow these steps: /Developer tab>Protect group & /Protect Document (b)>Restrict Formatting and Editing, in Task Pane’s Editing restrictions section check “Allow only this…” box and /its arrow>Tracked changes & /Yes, Start Enforcing Protection (b) and type in your password.
Now that’s protection! Okay, having password protection on a document is like having a Super Friend like Superman protecting you. Invincible he is until some krptonite is found - iyogi computer help services breaks the password, but better than nothing eh?
Friday, September 26, 2008
Microsoft Training Tips
When it comes to learning Microsoft Office, there are some real challenges for many individuals. First of all, most people simply open up Microsoft Office and try to navigate through the software without ever truly learning how to use it. This is all fine and good for those who are software savvy, but for those who are not it usually results in a lot of lost time and they still do not learn the program. So, what can individuals do who need to learn to use Microsoft Office but who really have no clue how to get started? For these people there are options like online Microsoft Office training. There are many benefits to online Microsoft Office training and it is highly recommended for anyone who will use this program.
For others who find that online training is not the right option for them then they can choose to use a Microsoft Office training CD. This training CD is an excellent option for anyone who wants to learn Microsoft Office or even those who are already familiar with the program but want to brush up on a few areas. It is so easy to sit down in front of a computer and simply start going through the tutorial and focusing on the areas where you really need help and skipping or just brushing over the ones that are not that important. You might dread taking a tutorial or course like this, but when you actually get involved in it you will realize that it really is a great idea and one that will help you significantly in your career and every day use of Microsoft Office.
There are some tips you should follow, however, before you begin taking any online class and tutorial. And, the first one is to prepare yourself to learn. If you go into the tutorial focusing on other things then you will never really learn all that Microsoft Office has to offer. The same goes for allotting time to take the training. If you are short on time and try to cram an hour's worth of tutorial into 15 minutes then you really will not benefit much from the tutorial. Because of this, it is really important that you focus on time allotment and make room for your Microsoft Office course. You will be glad you did in the end because you will learn so many different things about this software that you never knew and it will really help you in your job and daily life as a result.
| Caitlina Fuller is a freelance writer. For these people there are options like online Microsoft Office Support. There are many benefits to online Microsoft Office training and it is highly recommended for anyone who will use this program. For others who find that online training is not the right option for them then they can choose to use a Microsoft Office Support CD. This training CD is an excellent option for anyone who wants to learn Microsoft Office or even those who are already familiar with the program but want to brush up on a few areas. |
Subscribe to:
Posts (Atom)
