Affiliates

Amazon.com


Popular Microsoft Books

Excel 2003 Bible
Excel 2003 Bible
Author: John Walkenbach 

Excel 2003 for Dummies
Excel 2003 for Dummies
Author: Greg, PhD Harvey 

Microsoft Office Excel 2003 Step by Step
Microsoft Office Excel 2003 Step by Step
Author: Curtis Frye 

Excel VBA Programming For Dummies
Excel VBA Programming For Dummies
Author: John Walkenbach 

Excel 2003 Personal Trainer
Excel 2003 Personal Trainer
Author: Inc 

Microsoft Office Excel 2003 Inside Out
Microsoft Office Excel 2003 Inside Out
Author: Craig Stinson 

Excel 2003 All-in-One Desk Reference for Dummies
Excel 2003 All-in-One Desk Reference for Dummies
Author: Greg Harvey 

Popular Microsoft Related Websites

Microsoft Corporation 













Microsoft Excel Resources    

Welcome to MS Tips and Tricks
Welcome to MS Tips and Tricks - You are at the right place if you need tutorials for beginners - Online Microsoft Resource covering the following applications - MS Windows XP, MS Windows Vista, MS Word, MS Excel, MS Access, MS OutLook, etc.,

  Microsoft Excel Resources

When you run a VBA macro that animates a chart in Excel 2007, the chart animation may be slower than you expected 
Describes an issue that occurs when you run a VBA macro that animates a chart in Excel 2007.  

A "Placeholder for menu items to be added to Office 11" item is displayed when you right-click an item in a PivotTable in Excel 2007 
Describes an issue in which a "Placeholder for menu items to be added to Office 11" item is displayed when you right-click an item in a Pivot Table in Excel 2007. ... This issue may occur if you had a prerelease version of Excel 2007 installed on ... 

Three-dimensional charts may not print completely when you print a workbook in Excel 2007  
Describes a problem where a workbook that contains several pages of data may not completely print three-dimensional charts in Excel 2007.  

Chart data is deleted when you apply a template to an Excel chart in a 2007 Office program 
This problem occurs when you exit Microsoft Office Excel 2007 before you change the template of the chart. ... To work around this problem, click Edit Data on the Design tab to open the worksheet that contains the chart data in Excel 2007.  

Excel Services will not load workbooks from sites that are mapped to internal sites that are listed as trusted locations in SharePoint Server 2007  
Describes a problem in which you cannot access workbooks from sites that are mapped to internal sites that are listed as trusted locations in SharePoint Server 2007 Excel Services. ... For more information about how to add a trusted file location in Excel Services, visit ... 

A maximum number of 25 sessions can be active at the same time on Excel Services when you enable anonymous access to a SharePoint Server 2007 Web site 
Describes an issue that occurs when you enable anonymous access to a SharePoint Server 2007 Web site. By default, only 25 sessions can be active on Excel Services at the same time. ... SharePoint Server 2007 supports anonymous access by mapping anonymous users to a single user account.  

Changes to an Excel 2007 workbook may not be displayed when you resave the workbook to a SharePoint Server 2007 document library and then view the workbook in Excel Web Access 
Describes an issue that occurs when you save an Excel 2007 workbook to a document library, modify the workbook, and then resave the workbook to the document library. ... This behavior occurs because SharePoint Server 2007 uses the ... this problem, use any of the following methods: In the Excel Web Access ... 

The "Get Filter Values From" command is not displayed in the Connections menu when you try to edit an Excel Web Access Web Part in Excel Services 
a behavior in which the "Get Filter Values From" command is not displayed in the "Connections" menu when you try to edit an Excel Web Access ... The Web Part loads a Microsoft Office Excel 2007 PivotTable workbook from any location other than from a Windows SharePoint Services 3.0 document library.  

You cannot renew the connection to a PivotTable when you use an OLAP 8.0 connection to create the PivotTable in Excel 2007 
Describes a problem that occurs when you try to renew the connection to a PivotTable in Excel 2007.  

When you open an Excel 2007 workbook by using Excel Web Access, you are presented with a Security Information dialog box  
Describes a problem with Microsoft Office Excel 2007. When you try to open an Excel 2007 file by using Excel Web Access (EWA), you are presented with a Security Information dialog box. ... Additionally, you use Excel Web Access over a Secure Sockets Layer (SSL) connection.  

You receive a message when you try to run a macro in an encrypted workbook in Excel 2007: "Because of your security settings, macros have been disabled"  
Describes an issue in which you receive a "Because of your security settings, macros have been disabled" message when you try to run a macro in an encrypted workbook in Excel 2007. ... To do this, follow these steps: Create the original encrypted Excel workbook in Excel 2007, but do ... 

Error message when you update data in a PivotTable in Excel 2007: "Excel was unable to get necessary information about this cube" or "LocaleIdentifier property is not overwritable and cannot be assigned a new value" 
Describes a problem in which you receive an error message when you update data in a PivotTable in Excel 2007. 

You cannot send a chart in the body of an Outlook 2007 e-mail message when you use Excel 2007 to send the chart  
Describes behavior in which you cannot send a chart in the body of an Outlook 2007 e-mail message to a recipient in Excel 2007. ... To send to a recipient in Excel 2007, you must add Send Mail to Recipient to the Quick Access Toolbar. ... To work around this behavior, copy the chart from Excel 2007.  

Error message when you use a VBA macro to save a shared Excel 2007 workbook: "Application-defined or object-defined error"  
Describes a problem in which you receive an "Application-defined or object-defined error" error message when you use a VBA macro to save a shared Excel 2007 workbook. ... This issue may occur if the following conditions are true: The default save format is set to Excel 97-2003.  

The "Exchange Folder" menu command is missing in Excel 2007, in PowerPoint 2007, and in Word 2007 after you configure Outlook 2007 to use an Exchange e-mail account  
Describes an issue where the "Exchange Folder" menu item is missing in Excel 2007, in PowerPoint 2007, and in Word 2007. ... To do this, follow these steps: Start Excel 2007, PowerPoint 2007, or Word 2007.  

One or more sides of a spreadsheet are truncated when you use Word 2007 to post a blog entry that contains a Excel 2007 spreadsheet  
Describes a problem that occurs when you use Word 2007 to post a blog entry that contains a Excel 2007 spreadsheet.  

A data series border in a chart may overlap more in Excel 2007 than in an earlier version of Microsoft Excel  
Describes a behavior where a data series border in a chart may overlap more in Excel 2007 than in earlier versions of Microsoft Excel. ... Method 2: Reset the data series To reset the data series, right-click the data series in the Excel 2007 chart, and then click Reset to Match Style .  

You receive a message when you try to open or save a file type that has been blocked by your administrator in Excel 2007, in PowerPoint 2007, or in Word 2007  
Describes an issue in which you receive a message when you try to open or save a file type that has been blocked by your administrator in Excel 2007, in PowerPoint 2007, or in Word 2007. ... true: Your administrator has restricted the file types that you can open or save in Excel 2007, in PowerPoint ...  

The "Browse in same window" check box is unavailable for 2007 Office file types after you install the "Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats"  
Describes the issue in which you cannot select the "Browse in same window" check box for 2007 Office file ... Consider the following scenario: You install the Microsoft Office Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats (Beta 2 Technical Refresh).  

How to open and to save Word 2007, Excel 2007, and PowerPoint 2007 files in earlier versions of Office  
PowerPoint 2007 macro-enabled show (*.ppsm) Microsoft Office Excel 2007 Excel 2007 binary workbook (*.xlsb) Excel 2007 workbook (*.xlsx) Excel 2007 macro-enabled workbook (*.xlsm) Excel 2007 template (*.xltx) Excel 2007 macro-enabled template (*.xltm) Excel 2007 add-in ... 

The dialog box that appears when you click the "Select Multiple Objects" icon is empty in PowerPoint 2007 and in Excel 2007  
In Microsoft Office Excel 2007 and in Microsoft Office PowerPoint 2007, you customize the Quick Access Toolbar to include the Select Multiple Objects icon. ... To work around this issue in Excel 2007, click Selection Pane in the Arrange group on the Page Layout tab.  

Visual Basic for Applications is disabled by default in Excel 2007  
Describes that Visual Basic for Applications (VBA) is disabled by default in Excel 2007. ... To change how Excel 2007 handles macros, you may want to change the security settings. ... Note When you change the macro security settings in the Trust Center, the settings are changed only for Excel 2007.  

How to shade every other row in an Excel 2007 worksheet  
Describes how to shade every other row in an Excel 2007 worksheet. This article describes how to shade every other row in a Microsoft Office Excel 2007 worksheet. To shade every other row in an Excel 2007 worksheet, use one of the following methods.  

How to use a VBA macro to add labels to data points in an XY (scatter) chart or in a bubble chart in Excel 2007  
Describes how to use a VBA macro to add labels to data points in an XY (scatter) chart or in a bubble chart in Excel 2007. Microsoft Office Excel 2007 does not include a built-in command that automatically attaches text labels to data points in an XY (scatter) chart or in a bubble chart. 

You cannot use the Name box to rename a chart in Excel 2007  
Describes an issue in which you cannot use the Name box to rename a chart in Excel 2007.  

A data series may not be plotted as expected in a combination chart in Excel 2007  
Describes an issue in which a data series may not be plotted as expected in a combination chart in Excel 2007. ... For more information about a combination chart, follow these steps: Click Microsoft Office Excel Help , or press F1.  

When you open an Excel 2007 3-D chart in an earlier version of Excel, the lines or shapes that you drew may be shifted or resized  
Describes a workaround for an issue that occurs when you open an Excel 2007 3-D chart in an earlier version of Excel. ... To do this, follow these steps in Excel 2007: Select the chart.  

Add-ins that contain code to automatically perform a move operation or a copy operation do not work correctly in Excel 2007  
Describes a problem in which add-ins that contain code that automatically moves or copies a worksheet from one workbook to another workbook do not work correctly in Excel 2007. ... if you install an add-in that contains code to automatically perform a move operation or a copy operation in Excel 2007.  

Visual Basic for Applications returns an unexpected value when you use Visual Basic for Applications in Excel 2007 to obtain the value of the Border.Weight property of a shape object  
Describes a problem in Excel 2007 in which VBA returns an unexpected value when you use VBA to obtain the value of the Border.Weight property of a shape object. 

How to apply different passwords or permissions to separate ranges in worksheets in Excel 2007  
Describes how to apply different passwords or permissions to protect specific ranges of an Excel 2007 worksheet. This article describes how to apply different passwords to protect specific ranges of a Microsoft Office Excel 2007 worksheet. ... to separate ranges in an Excel 2007 worksheet, follow ... 

The destination cell in a new workbook contains the value "#N/A" when you paste a link to the copied cell in Excel 2007  
Describes a problem that may occur when you use the Paste Special feature to paste a cell from an Excel 2007 workbook into a new workbook by using Excel 2003 with the Microsoft Office Compatibility Pack installed. ... Open a new instance of Excel 2003.  

A hidden series in an Excel 2003 chart does not appear in the chart legend after you unhide the series in Excel 2007 
Describes a problem that occurs when you try to unhide a series in an Excel 2003 chart by using Excel 2007. ... To work around this problem, follow these steps in Excel 2007: Re-create the chart legend.  

DDE links are not automatically updated in Excel 2007  
Describes an issue in which Dynamic Data Exchange (DDE) links are not automatically updated in Excel 2007. ... This issue may occur if one of the following conditions is true: The Update links to other documents option is disabled in the Advanced section of the Excel Options dialog box.  

Error message when you click buttons for macros in the Excel 2007 Quick Access Toolbar: "Cannot run the macro"  
Describes an issue that causes some buttons for macros in the Excel 2007 Quick Access Toolbar to return an error message instead of running the macro. ... Open the file in Excel 2007. ... For more information about macro security settings, see Excel 2007 Help.  

Columns in a text box do not generate a compatibility conflict in the Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats when you open an Excel 2007 workbook in Excel 2003  
Describes a problem that occurs because the text box Columns setting in Excel 2007 is not flagged by the compatibility checker in the Compatibility Pack for Word, Excel, and PowerPoint 2007 File Formats. ... This problem occurs because the text box Columns setting in Excel 2007 is not ...  

You cannot select the Automatic option when you try to change the gridline color of a chart in Microsoft Office Excel 2007  
Describes the problem in Microsoft Office Excel 2007 in which you cannot select the Automatic option when you try to change the gridline color of a chart. ... To work around this problem, you can change the border color to automatic by using the Format Shape dialog box in Excel 2007.  

Shape properties in worksheets are not updated correctly in Microsoft Office Excel 2007  
Describes problem in Microsoft Office Excel 2007 when shape properties that are contained in worksheets are not updated in a timely manner. ... This problem occurs because shape properties are not updated in Excel 2007 until the code that is contained in the macro has run successfully.  

Limitations of the Break Links command in Excel  
Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002 include a feature that allows you to break external links within a workbook. ... In Excel 2007, on the Data tab, click Edit Links in the Connections group.  

An Excel chart is blank when you apply a custom chart template in a 2007 Office program  
Describes an issue that occurs after you create a custom chart template in Excel 2007.  

You cannot use the pointer to select a cell in Excel 2007 or in Excel 2003  
Describes a problem that occurs in Excel when you use the Simplified Chinese Wu Bi 86/98 IME. Consider the following scenario: In Microsoft Office Excel 2007 or in Microsoft Office Excel 2003, you open more than one window. ... To work around this problem, switch from Excel to another ... 
Advertisement



Advertisement



Copyright © MS Tips and Tricks
A Division of Gurijala and Company, 2006
Home - Tips and Tricks - Resources - Links - Contact - Site Map - Privacy Policy - Email Webmaster