Opening files in separate windows by default - Microsoft Community.

Looking for:

Force Excel to open in a new instance by default - Office | Microsoft Docs - Navigation menu 

Click here to DOWNLOAD

   

 

Microsoft office 2010 excel open in new window free. Can't open file excel 2010 in multiple windows

 

You can follow the question or vote as helpful, but you cannot reply to this thread. I have the same question Report abuse. Details required :. Cancel Submit. Right click on the Excel icon on the task bar and open a new instance of Excel and open the other workbook in that instance -- Hope this helps.

How satisfied are you with this reply? Thanks for your feedback, it helps us improve the site. Tony Jollans. This post describes the easiest ways to open two or more Excel files in separate windows or new instances without messing with the registry.

Having spreadsheets in two different windows makes many Excel tasks easier. One of the possible solutions is viewing workbooks side by side , but this eats a lot of space and isn't always the best option.

Opening an Excel document in a new instance is something more than just the ability to compare or view sheets next to each other. It's like having a few different applications running at the same time - while Excel is busy recalculating one of your workbooks, you can continue working on another.

In this interface type, multiple child windows reside under a single parent window, and only the parent window has a toolbar or menu bar. Therefore, in these Excel versions, all workbooks are opened in the same application window and share a common ribbon UI toolbar in Excel and earlier.

In Excel and older versions, there are 3 ways to open files in multiple windows that actually work. Each window is, in fact, a new instance of Excel. If you often have to open multiple Excel windows simultaneously, see this advanced shortcut solution.

It is actually easier than it may seem, just try it:. AppData folder is hidden. To make it visible, go to Folder options in Control Panel, switch to View tab and select Show hidden files, folders, or drives.

Paste the shortcut into the SendTo folder. Now, you can avoid opening additional files from within Excel. There are two other solutions that work for many people. This tweak works with all Excel files, including files you open yourself and files that programs open via Excel. Do not modify anything else. Click OK when you have finished. Ensure you rename the command registry entry and not the command folder.

Keep in mind, if you ever update Microsoft Office or apply a patch, you will need to repeat these steps because updates override the registry changes you just made. I really hope Microsoft adds an option within Excel in future versions to open files in new windows; but until they do, this registry tweak allows you to easily and quickly force Excel to open all files in new windows. This thread is locked. You can follow the question or vote as helpful, but you cannot reply to this thread. Threats include any threat of suicide, violence, or harm to another.

Any content of an adult theme or inappropriate to a community web site. Any image, link, or discussion of nudity. Any behavior that is insulting, rude, vulgar, desecrating, or showing disrespect.

Any behavior that appears to violate End user license agreements, including providing product keys or links to pirated software. Unsolicited bulk mail or bulk advertising. Any link to or advocacy of virus, spyware, malware, or phishing sites. Any other inappropriate content or behavior as defined by the Terms of Use or Code of Conduct.

 

Microsoft office 2010 excel open in new window free.Double-clicking an Office file fails to open it in the correct Office program

 

Imports the contents of an. If Outlook is already open, queues the profile to be imported on the next clean start. Provides a way for the user to add an e-mail name to the item.

Loads the specified profile. If your profile name contains a space, enclose the profile name in quotation marks " ". Opens the Choose Profile dialog box regardless of the Options setting on the Tools menu. Starts Outlook by using an existing Outlook window, if one exists.

Note: This is the same command as Upgrade to Color Categories in each Outlook mailbox properties dialog box. Resets default folder names such as Inbox or Sent Items to default names in the current Office user interface language.

For example, if you first connect to your mailbox in Outlook by using a Russian user interface, the Russian default folder names cannot be renamed. To change the default folder names to another language, such as Japanese or English, you can use this switch to reset the default folder names after you change the user interface language or install a different language version of Outlook.

Empties the form regions cache and reloads the form region definitions from the Windows registry. Attempts to open the same profile and folders that were open prior to an abnormal Outlook shutdown. Starts Outlook without the Reading Pane or toolbar customizations. Starts Outlook and opens the specified folder in a new window. Specifies a sharing URL to connect to Outlook. Starts Outlook, forces a detection of new meeting requests in the Inbox , and then adds them to the calendar.

Opens the specified database or Microsoft Access project. You can include a path, if necessary. If the path contains spaces, enclose it in quotation marks. Opens the specified Access database for exclusive access. To open the database for shared use in a multiuser environment, omit this switch. Applies to Access databases only. Starts Access by using the options in the specified user profile instead of the standard Windows Registry settings created when you installed Access.

To compact to a different name, specify a target file. If you include a path that contains spaces, enclose the path in quotation marks. If you specify a file name in the target database or target Access project parameter but you don't include a path, the target file is created in the default database folder that is specified in Access. You can change this setting in the Access Options dialog box.

In an Access project, this option compacts the Access project. Another way to run a macro when you open a database is to create a macro named AutoExec. Macros can contain viruses, so you must be careful about running them.

Take the following precautions: run up-to-date antivirus software on your computer; use the Trust Center to disable all macros except those that are digitally signed; maintain a list of trusted sources of macros. Specifies that what follows on the command line is the value that will be returned by the Command function. This option must be the last switch on the command line. Word winword.

In Windows 8, press the Windows key, type Run , and then press Enter. Note the following about using command-line switches: You can use only one switch at a time. Switches and parameters are not case-sensitive. Include one blank space before each switch and one before each parameter. The wizard creates the shortcut and places it on the desktop. Whenever you want to use the shortcut to start the app, double-click it. Switch and parameter Description workbook path file name This parameter does not require a switch.

Starts Excel and opens the specified file. Example excel. Here are the command-line switches that are available for PowerPoint. All custom views you created are lost.

Examples: Outlook. Upgrades calendar labels to Outlook color categories. Adds all categories used on non-mail items into the Master Category List Note: This is the same command as Upgrade to Color Categories in each Outlook mailbox properties dialog box.

Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue.

Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback! Starts Word with a new document based on a template other than the Normal template. Starts Word and opens an existing file. Starts Word with a new document based on an existing file. Starts Word and then loads a specific Word add-in.

Opens a specific workbook as read-only. Starts Excel and opens the specified file as a template. Prevents the Excel startup screen from appearing and a new blank workbook from opening.

Creates a new workbook that contains a single XLM macro sheet. Starts Excel and loads the Automation add-in that is specified by the progID of the add-in.

Starts a new instance a separate process of Excel. Starts PowerPoint with a new blank presentation. Runs a macro in a specified presentation. Starts PowerPoint and creates a new presentation. Starts PowerPoint and specifies a list of files to open. Prints the presentation to the default printer by using default settings. Prints the presentation to the specified printer by using the default settings.

Prints the specified file, but show the Print dialog box. Opens the specified presentation file as a slide show. Shows the Open dialog box when the presentation ends. Reads a playlist of PowerPoint presentations contained within a text file. Opens the presentation at a specified slide number, instead of slide 1.

Starts the viewer without showing the splash screen. Sends the presentation to a printer, and print the file. Creates an item with the specified file as an attachment. Prompts for the default manager of e-mail, news, and contacts. Removes all names and e-mail addresses from the Auto-Complete list.

Deletes the logging records saved when a manager or a delegate declines a meeting. Resets all Search Folders in the Microsoft Exchange mailbox for only the first profile opened. Removes all manually added From entries from the profile. Removes all MailTips from the cache.

Starts Outlook and deletes client-based and server-based rules. Deletes the subscription messages and properties for subscription features. Restores default views. Used without command-line parameters for standard OLE co-create. Opens the specified message file. Opens a Help window with the Help topic specified in assetid displayed. This workbook contains worksheets that have even page or first page headers and footers.

These page headers and footers cannot be displayed in earlier versions of Excel. What it means Beginning with Excel , you have the option to display different header and footer text on even pages or on the first page. In Excel , even page or first page headers and footers cannot be displayed, but they remain available for display when you open the workbook in Excel and later again. What to do If you frequently save a workbook to Excel file format, it is best not to specify even or first page headers or footers for that workbook.

Some cells or styles in this workbook contain formatting that is not supported by the selected file format. These formats will be converted to the closest format available. What it means Beginning with Excel , different cell formatting or cell style options, such as special effects and shadows, are available. These options are not available in Excel What to do When you continue saving the workbook, Excel applies the closest available format, which can be identical to another format you applied to something else.

To avoid duplication of formats, you can change or remove the cell formatting and cell styles that are not supported before you save the workbook to Excel file format. This workbook contains more unique cell formats than are supported by the selected file format. Some cell formats will not be saved.

What it means Beginning with Excel , you can use 64, unique cell formats, but in Excel , you can only use up to 4, unique cell formats. Unique cell formats include any specific combination of formatting that is applied in a workbook. What to do To avoid losing specific cell formats that you want to keep available in Excel , you can remove some cell formats that are not as important to keep.

This workbook contains more unique font formats than are supported in the selected file format. Some font formats will not be saved. What it means Beginning with Excel , 1, global font types are available, and you can use up to of them per workbook. Excel supports less unique font formats. What to do To avoid losing specific font formats that you want to keep available in Excel , you can remove some font formats that are not as important to keep.

For more information about how to resolve one or more of these compatibility issues, see the following articles:. Move or copy cells and cell contents. Headers and footers in worksheets. Unsupported Excel table features can cause the following compatibility issues, leading to a minor loss of fidelity. The table contains a custom formula or text in the total row. In earlier versions of Excel, the data is displayed without a table. What it means Although the formulas and text remain intact in Excel , the range will no longer be in table format.

What to do In the Compatibility Checker, click Find to locate the table that contains a custom formula or text, remove that formula or text from the total row, and then use only formulas that are available in the total row. A table in this workbook does not display a header row. What it means In Excel , a table cannot be displayed without a header row. What to do In the Compatibility Checker, click Find to locate the table that is displayed without a header row, and then display a header row. A table style is applied to a table in this workbook.

Table style formatting cannot be displayed in earlier versions of Excel. What it means In Excel , theme-based table styles are not available and cannot be displayed. What to do In the Compatibility Checker, click Find to locate the table that has a table style applied, remove that table style, and then format the table manually.

A table in this workbook is connected to an external data source. Table functionality will be lost, but the data remains connected. If table rows are hidden by a filter, they remain hidden in an earlier version of Excel. What it means Table functionality is lost in Excel What to do In the Compatibility Checker, click Find to locate the table that is connected to an external data source, and then disconnect the table from the external data source.

In Excel , you can then connect the data to the external data source again. Table functionality will be lost, as well as the ability to refresh or edit the connection.

Alternative text is applied to a table in this workbook. Alternative text on tables will be removed in versions prior to Excel What it means Alternative text is not available in Excel , and cannot be displayed in these earlier versions of Excel.

What to do In the Compatibility Checker, click Find to locate the Excel table that contains alternative text. To display the alternative text in the earlier version of Excel, you can copy it into a blank cell on the worksheet, or you could insert a comment that contains the text. Right-click anywhere in the table, click Table , and then click Alternative Text. For more information about how to resolve one or more of these compatibility issues, see the following article:.

Create or delete an Excel table in a worksheet. Unsupported PivotTable features can cause the following compatibility issues, leading to a significant loss of functionality or a minor loss of fidelity. A PivotTable in this workbook exceeds former limits and will be lost if it is saved to earlier file formats.

What it means Beginning with Excel , a PivotTable report supports 1,, unique items per field, but in Excel , only 32, items per field are supported. Save the workbook to Excel format, and then re-create this PivotTable report in Compatibility Mode.

A PivotTable in this workbook contains conditional formatting rules that are applied to cells in collapsed rows or columns. To avoid losing these rules in earlier versions of Excel, expand those rows or columns.

What it means Conditional formatting rules that are applied to cells in collapsed rows or columns will be lost in Excel What to do In the Compatibility Checker, click Find to locate the collapsed rows or columns that contain conditional formatting rules, and then expand those rows or columns before you save the workbook in an earlier Excel file format. This workbook contains named sets which are not associated with a PivotTable. These named sets will not be saved.

What it means Named sets that are not associated with a PivotTable will be removed in Excel What to do To avoid this issue, make sure that you create a PivotTable by using a connection. A PivotTable in this workbook has what-if analysis turned on. Any unpublished what-if changes will be lost in earlier versions of Excel. What it means What-if analysis changes that are not published to the server are not displayed in the earlier version of Excel.

What to do Make sure that you publish the what-if analysis changes before you open the workbook in an earlier version of Excel PivotTable Tools , Options tab, Tools group, What-If Analysis button. A PivotTable in this workbook contains a data axis upon which the same measure appears more than once. This PivotTable will not be saved.

The PivotTable cannot be displayed in Excel What to do In the Compatibility Checker, click Find to locate the PivotTable report that contains a data axis upon which more than one of the same measure appears, and then remove any duplicate measures so that only one measure remains. A PivotTable or data connection in this workbook contains server settings which do not exist in earlier versions of Excel. Some PivotTable or data connection server settings will not be saved.

What it means Some PivotTable or data connection server settings that are not available in Excel will be lost. What to do Verify that the server settings you use are compatible with earlier versions of Excel and then make the necessary changes PivotTable Tools , Options tab, Data group, Change Data Source button, Connection Properties command. These custom outputs will not be saved, and will be replaced by the original values from the data source.

Alternative text is applied to a PivotTable in this workbook. Alternative text on PivotTables will be removed in versions prior to Excel A PivotTable style is applied to a PivotTable in this workbook. PivotTable style formatting cannot be displayed in earlier versions of Excel.

What it means Theme-based PivotTable styles are not available in Excel and cannot be displayed. What to do In the Compatibility Checker, click Find to locate the PivotTable report that has a PivotTable style applied, remove that PivotTable style, and then manually apply PivotTable formatting that is supported in the earlier versions of Excel.

A PivotTable in this workbook will not work in versions prior to Excel What it means A PivotTable report you create in Excel and later cannot be refreshed in Excel What to do In the Compatibility Checker, click Find to locate the PivotTable report that is created in the current file format.

Save the workbook to Excel format, and then re-create this PivotTable report in Compatibility Mode so that you can open it in Excel without loss of functionality. A PivotTable in this workbook has fields in compact form.

In earlier versions of Excel, this layout will be changed to tabular form. What it means Compact form alone or in combination with tabular and outline form to keep related data from spreading horizontally off of the screen and to help minimize scrolling is not available in Excel , and fields will be displayed in tabular form. A PivotChart in this workbook has specific field buttons enabled or disabled.

All field buttons will be saved as enabled. What it means Field buttons that are not shown on a PivotChart will be saved as enabled when open and save the workbook in an earlier version of Excel. Slicers will not work in earlier versions of Excel. What it means Slicers were not introduced until Excel What to do In the earlier version of Excel, you can use PivotTable filters to filter data. Slicers will not be saved. What it means Slicers are not supported in Excel and cannot be shown.

When you refresh the connection or update a PivotTable, the filters that were applied by the slicers are no longer displayed, and the slicers will be lost. What to do Use PivotTable filters instead of slicers to filter the data.

A slicer style exists in this workbook, and is not supported in earlier versions of Excel. This slicer style will not be saved. What it means A custom slicer style will be lost when the workbook is saved to the file format of an earlier version of Excel.

What to do Change the custom slicer style to a built-in slicer style before you save the workbook to an earlier Excel file format Slicer Tools , Options tab, Slicer Styles gallery. A PivotTable in this workbook contains one or more fields that contain repeated labels.

If the PivotTable is refreshed, these labels will be lost. What it means Repeated labels are not supported in Excel , and the labels will be lost when you refresh the PivotTable report in the earlier version of Excel. Add, change, or clear conditional formats. Unsupported sorting and filtering features can cause the following compatibility issues, leading to a minor loss of fidelity.

A worksheet in this workbook contains a sort state with more than three sort conditions. This information will be lost in earlier versions of Excel. What it means Beginning with Excel , you can apply sort states with up to sixty-four sort conditions to sort data by, but Excel supports sort states with up to three conditions only.

To avoid losing sort state information in Excel , you may want to change the sort state to one that uses no more than three conditions. In Excel , you can also sort the data manually. However, all sort state information remains available in the workbook and is applied when the workbook is opened again in Excel and later, unless the sort state information is edited in Excel What to do In the Compatibility Checker, click Find to locate the data that has been sorted with more than three conditions, and then change the sort state by using only three or less conditions.

A worksheet in this workbook contains a sort state that uses a sort condition with a custom list. What it means Beginning with Excel , you can sort by a custom list. To get similar sorting results in Excel , you can group the data that you want to sort, and then sort the data manually. What to do In the Compatibility Checker, click Find to locate the data that has been sorted by a custom list, and then change the sort state so that it no longer contains a custom list.

A worksheet in this workbook contains a sort state that uses a sort condition that specifies formatting information. What it means Beginning with Excel , you can sort data by a specific format, such as cell color, font color, or icon sets.

In Excel , you can sort only text. What to do In the Compatibility Checker, click Find to locate the data that has been sorted by a specific format, and then change the sort state without specifying formatting information.

Some data in this workbook is filtered in a way that is not supported in earlier versions of Excel. Rows that are hidden by the filter will remain hidden, but the filter itself will not display correctly in earlier versions of Excel. What it means Beginning with Excel , you can apply filters that are not supported in Excel To avoid losing filter functionality, you may want to clear the filter before you save the workbook in an earlier Excel file format.

In Excel , you can then filter the data manually. However, all filter state information remains available in the workbook and is applied when the workbook is opened again in Excel and later, unless the filter state information is edited in Excel What to do In the Compatibility Checker, click Find to locate the data that has been filtered, and then you can clear the filter to unhide the rows that are hidden.

Some data in this workbook is filtered by a cell color. What it means Beginning with Excel , you can filter by a cell color, font color, or icon set — these methods are not supported in Excel Some data in this workbook is filtered by a font color. Some data in this workbook is filtered by a cell icon. Some data in this workbook is filtered by more than two criteria.

What it means Beginning with Excel , you can filter data by more than two criteria. Some data in this workbook is filtered by a grouped hierarchy of dates, resulting in more than two criteria.

What it means Beginning with Excel , you can filter dates by a grouped hierarchy. Because this is not supported in Excel , you may want to ungroup the hierarchy of dates. If you're using Excel , press the Office button , then Excel Options. Unsupported formula features can cause the following compatibility issues, leading to a significant loss of functionality or a minor loss of fidelity. Some worksheets contain more array formulas that refer to other worksheets than are supported by the selected file format.

What it means Beginning with Excel , workbook arrays that refer to other worksheets are limited only by available memory, but in Excel , worksheets can only contain up to 65, workbook arrays that refer to other worksheets. What to do In the Compatibility Checker, click Find to locate cells that contain array formulas that refer to another worksheet, and then make the necessary changes to avoid VALUE!

What it means Beginning with Excel , the maximum length of formula contents is 8, characters, and the maximum internal formula length is 16, bytes. In Excel , the maximum length of formula contents is 1, characters, and the maximum internal formula length is 1, bytes. What to do In the Compatibility Checker, click Find to locate the cells that contain formulas that exceed the maximum formula length limits of Excel , and then make the necessary changes to avoid VALUE!

Some formulas have more levels of nesting than are supported by the selected file format. What it means Beginning with Excel , a formula can contain up to 64 levels of nesting, but in Excel , the maximum levels of nesting is only 7.

What to do In the Compatibility Checker, click Find to locate the cells that contain formulas with more than 7 levels of nesting, and then make the necessary changes to avoid VALUE! Some formulas contain functions that have more arguments than are supported by the selected file format. Formulas that have more than 30 arguments per function will not be saved and will be converted to VALUE! What it means Beginning with Excel , a formula can contain up to arguments, but in Excel , the maximum limit of arguments in a formula is only What to do In the Compatibility Checker, click Find to locate the cells that contain formulas with more than 30 arguments, and then make the necessary changes to avoid VALUE!

Some formulas use more operands than are allowed by the selected file format. What it means Beginning with Excel , the maximum number of operands that can be used in formulas is 1,, but in Excel , the maximum limit of operands in formulas is only What to do In the Compatibility Checker, click Find to locate the cells that contain formulas with more than 40 operands, and then make the necessary changes to avoid VALUE!

Some formulas contain functions with more arguments than are supported by the selected file format. What to do In the Compatibility Checker, click Find to locate the cells that contain functions that use more than 29 arguments, and then make the necessary changes to avoid VALUE! You may have to use VBA code to change user-defined functions.

One or more functions in this workbook are not available in earlier versions of Excel. When recalculated in earlier versions, these functions will return a NAME? What it means Beginning with Excel , new and renamed functions were added. What to do In the Compatibility Checker, click Find to locate the cells that contain functions that are not available in earlier versions of Excel, and then make the necessary changes to avoid NAME?

Compatibility functions are available for all functions that have been renamed. To avoid errors, you can use those functions instead. New functions can be replaced with appropriate functions that are available in the earlier versions of Excel. You can also remove formulas that use new functions by replacing them with the formula results. Some formulas contain references to tables that are not supported in the selected file format.

These references will be converted to cell references. What it means Beginning with Excel , you can use structured references to make it much easier and more intuitive to work with table data when you are using formulas that reference a table, either portions of a table, or the entire table. This feature is not supported in Excel , and structured references will be converted to cell references. What to do In the Compatibility Checker, click Find to locate the cells that contain formulas with structured references to tables so that you can change them to the cell references that you want to use.

Some formulas contain references to tables in other workbooks that are not currently open in this instance of Excel. These references will be converted to REF on save to Excel format because they cannot be converted to sheet references.

However, if the structured references point to tables in other workbooks that are not currently open, they will be converted to and displayed as REF errors. What to do In the Compatibility Checker, click Find to locate the cells that contain formulas with structured references to tables in other workbooks so that you can change them to avoid REF errors. One or more cells in this workbook contain data validation rules which refer to more than discontinuous areas of cells.

These data validation rules will not be saved. What it means Beginning with Excel , data validation rules can refer to more than discontinuous areas of cells. In Excel , this type of data validation rule is not supported and won't be available. What to do In the Compatibility Checker, click Find to locate cells that contain data validation rules that refer to more than discontinuous areas of cells, and then make the necessary changes. One or more cells in this workbook contain data validation rules which refer to values on other worksheets.

These data validation rules will not be supported in earlier versions of Excel. What it means Beginning with Excel , you can implement data validation rules that refer to values on other worksheets. This is not supported in Excel What to do In the Compatibility Checker, click Find to locate the cells that contain data validation rules that refer to values on other worksheets, and then make the necessary changes so that the data validation rules refer to values on the same worksheet.

What it means Beginning with Excel , you can use data validation rules that refer to values on other worksheets. In Excel , this type of data validation is not supported and cannot be displayed on the worksheet. However, all data validation rules remain available in the workbook and are applied when the workbook is opened again in Excel and later, unless the rules were edited in Excel What to do In the Compatibility Checker, click Find to locate cells that contain data validation rules that refer to values on other worksheets, and then make the necessary changes on the Settings tab of the Data Validation dialog box Data tab, Data Tools group.

This workbook contains a Data Consolidation Range with references to cells outside of the row and column limits of the selected file format. Formula references to data in this region will be adjusted and may not display correctly in an earlier version of Excel. What it means Beginning with Excel , data consolidation ranges can contain formulas that refer to data outside of the row and column limit of the selected file format.

In Excel , worksheet size of 65, rows tall by columns wide. Formula references to data in cells outside of this column and row limit are adjusted and may not display correctly. What to do In the Compatibility Checker, click Find to locate data consolidation ranges that contain formula references to data outside of the row and column limit of Excel , and then make the necessary changes.

Some array formulas in this workbook refer to an entire column. In earlier versions of Excel, these formulas may be converted to NUM! What it means Beginning with Excel , array formulas that refer to an entire column will be converted to and displayed as NUM! What to do In the Compatibility Checker, click Find to locate the array formulas that refer to an entire column so that you can make the necessary changes to avoid NUM errors.

One or more defined names in this workbook contain formulas that use more than the characters allowed in the selected file format. These formulas will be saved but will be truncated when edited in earlier versions of Excel.

What it means When named ranges in formulas exceed the character limit that is supported in Excel , the formula will work correctly, but it will be truncated in the Name dialog box and cannot be edited. What to do In the Compatibility Checker, click Find to locate cells that contain named ranges in formulas, and then make the necessary changes so that users can edit the formulas in Excel Some formulas in this workbook are linked to other workbooks that are closed. When these formulas are recalculated in earlier versions of Excel without opening the linked workbooks, characters beyond the character limit cannot be returned.

What it means When formulas in a workbook are linked to other workbooks that are closed, they can only display up to characters when they are recalculated in Excel The formula results might be truncated. What to do Find the cells that contain formulas that link to other workbooks that are closed so that you can verify the links and make the necessary changes to avoid truncated formula results in Excel What it means When Data Validation formulas exceed the character limit that is supported in Excel , the formula will work correctly, but it will be truncated and cannot be edited.

What to do In the Compatibility Checker, click Find to locate cells that contain Data Validation formulas, and then use fewer characters in the formula so that users can edit them in Excel Some formulas contain arrays with more elements than are supported by the selected file format. Arrays with more than columns or rows will not be saved and may produce different results. What it means Beginning with Excel , you can use array formulas that contain elements for more than columns and rows.

In Excel , this exceeds the limit for array elements and might return different results. What to do In the Compatibility Checker, click Find to locate cells that contain array formulas that have more elements than are supported in earlier versions of Excel, and then make the necessary changes. All custom descriptions will be removed. Custom descriptions are not supported in Excel and will be removed. What to do No action is needed because all custom descriptions will be removed.

For more information about how to resolve one or more of these compatibility issues, see What's New: Changes made to Excel functions. Unsupported conditional formatting features can cause the following compatibility issues, leading to a significant loss of functionality.

Some cells have more conditional formats than are supported by the selected file format. Only the first three conditions will be displayed in earlier versions of Excel. What it means Beginning with Excel , conditional formatting can contain up to sixty-four conditions, but in Excel , you will see the first three conditions only. However, all conditional formatting rules remain available in the workbook and are applied when the workbook is opened again in Excel and later, unless the rules were edited in Excel What to do In the Compatibility Checker, click Find to locate cells that have conditional formatting applied that use more than three conditions, and then make the necessary changes to use no more than three conditions.

Some cells have overlapping conditional formatting ranges. Earlier versions of Excel will not evaluate all of the conditional formatting rules on the overlapping cells. The overlapping cells will show different conditional formatting. What it means Overlapping conditional formatting ranges are not supported in Excel , and the conditional formatting is not displayed as expected. What to do In the Compatibility Checker, click Find to locate cells that have overlapping conditional formatting ranges, and then make the necessary changes to avoid overlap.

One or more cells in this workbook contain a conditional formatting type that is not supported in earlier versions of Excel, such as data bars, color scales, or icon sets. What it means In Excel , you will not see conditional formatting types, such as data bars, color scales, icon sets, top or bottom ranked values, above or below average values, unique or duplicate values, and table column comparison to determine which cells to format.

What to do In the Compatibility Checker, click Find to locate cells that have conditional formatting types that are new in Excel and later, and then make the necessary changes to use only formatting types that are supported in the earlier versions of Excel.

Some cells contain conditional formatting with the 'Stop if True' option cleared. Earlier versions of Excel do not recognize this option and will stop after the first true condition. What it means In Excel , conditional formatting without stopping when the condition has been met is not an option.

Conditional formatting is no longer applied after the first condition is true. What to do In the Compatibility Checker, click Find to locate cells that contain conditional formatting with the Stop if True option cleared, and then click Fix to resolve the compatibility issue.

This is not supported in earlier versions of Excel. What it means In Excel , you will not see conditional formatting in nonadjacent cells. What to do In the Compatibility Checker, click Find to locate cells that contain a conditional formatting type on a nonadjacent range, and then make the necessary changes to use conditional formatting rules that are available in earlier versions of Excel.

Some PivotTables in this workbook contain conditional formatting that may not function correctly in earlier versions of Excel. The conditional formatting rules will not display the same results when you use these PivotTables in earlier versions of Excel.

What it means Conditional formatting results you see in Excel PivotTable reports will not be the same as in PivotTable reports created in Excel and later. What to do In the Compatibility Checker, click Find to locate PivotTable report fields that contain conditional formatting rules, and then apply conditional formatting rules that are available in the earlier versions of Excel.

One or more cells in this workbook contain conditional formatting which refers to values on other worksheets. These conditional formats will not be supported in earlier versions of Excel. What it means In Excel , conditional formatting that refers to values on other worksheets is not displayed.

What to do In the Compatibility Checker, click Find to locate cells that contain conditional formatting that refers to values on other worksheets, and then apply conditional formatting that does not refer to values on other worksheets. One or more cells in this workbook contain conditional formatting using the 'Text that contains' format with a cell reference or formula. What it means In Excel , conditional formatting that use formulas for text that contains rules is not displayed on the worksheet.

What to do In the Compatibility Checker, click Find to locate cells that contain conditional formatting that uses formulas for text that contains rules, and then apply conditional formatting that is supported in earlier versions of Excel.

One or more cells in this workbook contain a rule that will not be supported in earlier versions of Excel because there is a formula error in its range. What it means In Excel , conditional formatting that use range-based rules cannot be displayed correctly on the worksheet when the range-based rules contain formula errors.

What to do In the Compatibility Checker, click Find to locate cells that contain range-based rules that contain formula errors, and then make the necessary changes so that range-based rules do not contain formula errors.

One or more cells in this workbook contain a conditional formatting icon set arrangement that is not supported in earlier versions of Excel. What it means In Excel , conditional formatting that displays a specific icon set arrangement is not supported and the icon set arrangement is not displayed on the worksheet.

However, all conditional formatting rules remain available in the workbook and are applied when the workbook is opened again in Excle and later, unless the rules were edited in Excel What to do In the Compatibility Checker, click Find to locate cells that contain conditional formatting that display a specific icon set arrangement, and then make sure that conditional formatting does not display that icon set arrangement.

One or more cells in this workbook contain a data bar rule that uses a "Negative Value" setting.

   

 

- Open Excel files in separate windows and multiple instances

   

Outlook has seen many notable feature improvements in Office , which will save users time in their daily e-mail tasks if they get past the initial learning curve.

The new Conversation View lets you group threads together so you can view an entire conversation in one place. With plenty of competition in Google's online Gmail search tools, Outlook needed to make attractive new features to continue to be competitive, and this feature makes searching through e-mail much easier. You also can run Clean Up to strip out redundant messages and threads so you have just the info you need without scanning through several e-mails.

Microsoft got mixed reviews during beta testing of this feature, but we think that this might be one of those features like the Ribbon that will become more useful as users become acclimated with a new way of doing things. A new feature called Quicksteps lets you create macros for common daily tasks like regular forwarding of specific e-mails to third parties.

Say you have sales e-mails from several parties that are sent to you on a regular basis, but need to go to another person within your company. With Quicksteps you could custom create a macro that would automatically send that e-mail on with the click of a button.

Like the Conversation View features, Quicksteps is not immediately intuitive, but after some study, it will save you an enormous amount of time processing e-mails in the future. Even with the tweaks for simplifying your e-mail processing, Outlook still seems more in tune with large business clients than with smaller companies that could probably get by with online alternatives.

New coauthoring in Word, PowerPoint, and OneNote, as well as advanced e-mail management and calendaring capabilities in Outlook, make collaboration much easier, reducing the time it takes to finish large projects with several contributors.

Word and PowerPoint now have a syncing mechanism to avoid sudden changes while you're working on a project a major concern in the beta.

We wonder how people will react to this specific change, since now the only way to have live coauthoring without the need to sync up changes will be through OneNote.

In any case, offering access to shared documents in key business applications from anywhere is something any international business or business traveler can appreciate. Google Docs, though not as elegant, are extremely easy to share with other users, so offering OneNote as the only option may not be enough. Live edits in OneNote are only one of the new features for Microsoft's notebook-like application, however.

Sketching out ideas, collaborating in real time, and adding images, video, audio, and text are all available in OneNote as it sits to the side of what you're working on. This enables you to drop sections of text, images, and other tidbits into OneNote's interface to keep all your ideas in one place. An upgraded Navigation Bar makes it easy to jump between notebooks to copy or merge information. When you're collaborating on a project, OneNote now features automatic highlighting so you can quickly find changes to your notebook since your last save.

Features like these, along with new visual styles and a Web version with live changes, make OneNote the key collaborative tool of the suite. Our only question is whether people will accept OneNote as their mainstay for live collaboration since it has less name recognition than bigger apps in the suite. In addition to upgraded collaboration tools, you'll now be able to work on your documents anywhere with slimmed down Web-based versions of Word, PowerPoint, Excel, and OneNote. The Web based components will make sharing information easier whether it's from your home computer, your phone, or when you're traveling for business.

The Web apps preserve the look and feel of a document regardless of the device you're working on--even if it's your smartphone. These apps seem to work as advertised mostly, but we wonder how well the Web-based versions will work when server loads reach into the several millions of users.

What sets these apps apart from Google Docs and other services is that your documents and spreadsheets retain their formatting, giving Office 's Web apps a leg up against its online counterparts. Excel has received some tweaks as well, with easier-to-read, color-coded spreadsheets and smart tools to bring in the information you need. In Excel , you can flip through the tabs to access formulas, insert diagrams and charts, and quickly import data from connected sources.

A new feature called Sparklines lets you create a small chart in a single cell. This lets users compare data across multiple cells with added graphical elements to make them easier to read and spot trends over time. These moves seem to suggest that Microsoft is trying to make spreadsheets a little more accessible to a wider swath of users.

We welcome the new customization features, especially as Excel retains the powerful tools users have come to expect. Those who are involved in creating their own publications and newsletters will appreciate new changes to Publisher With several available templates, you can add your personal business logo graphics and branding and then preview them in real time across each template style.

Microsoft has added ligatures and Stylistic Alternates to fonts so you can add your own personal touches to your publications. Like the other applications we've talked about in Office , Publisher offers the same new useful image-editing tools, so effects, color-correction, cropping, and more are only a few clicks away. Late to our labs and late to the game, some might say, with Google and Yahoo leading the pack are some of the new features that Windows Live Hotmail will support when it launches to all users in July or August.

Microsoft says users will be offered the option to upload Office documents or images to their SkyDrives, and then send a link of their work to a friend who uses Hotmail. This will eliminate the need to use caution when sharing large files for presentations, videos, or large collections of photos, because the documents will exist in the cloud. The recipient will be able to view documents in their original format and large multimedia files in their Inbox without the need to wait for a huge download.

This gives Hotmail users the opportunity to pick and choose which content they want to download from SkyDrive. As a result of new feature additions to Hotmail, images and video will receive new options, too, including the ability to automatically view a collection of images in a slideshow, and the ability to view photos and video from third-party services like FlickR, SmugMug, Hulu, and YouTube, all without having to leave Hotmail.

Microsoft also says it will push Windows live e-mail, calendar, and contact information, and more to your Windows Mobile phone using Exchange ActiveSync. Other new features we saw in the demo included separate sections for viewing shipping information and e-mails from social Web sites, which represent a significant amount of all e-mail messages. Does Office offer enough to make it worth the upgrade from earlier versions? We think that largely depends on how you use Microsoft Office.

New templates and quick access to video and image-editing tools are welcome additions for those who create visual presentations of their content. Serious spreadsheet power users will like the new features that tie data together in Excel while making complex data more accessible in the Ribbon and more exciting visually. Outlook's new conversation-scrubbing features and Quicksteps for common e-mail actions could save daily e-mail users a lot of time, if they're willing to learn the ropes initially.

If you feel like Office or Office have all the features you need in your line of work, then there's probably little reason to upgrade. Obviously, the Ribbon is now the preferred method across the entire suite for getting to features quickly. If you didn't like the Ribbon in Office , you probably won't like it now, but we think there's plenty of utility in having a common interface tool across all the apps; it might be worth learning a new way of doing things if you want to streamline your work flow.

The new Hotmail integration features that will launch alongside Office may give Google Docs a run for its money if they work as advertised. Archived from the original on May 15, Archived from the original on March 3, Retrieved March 10, Archived from the original on October 7, Retrieved November 3, Archived from the original on August 14, Retrieved August 11, Archived from the original on December 19, Retrieved November 7, June 28, Retrieved January 27, July 16, Archived from the original on December 31, The Register.

Situation Publishing. Archived from the original on November 7, Retrieved November 6, Archived from the original on December 7, Support 2. Archived from the original on July 1, April 8, Archived from the original on September 10, Archived from the original on January 20, April 26, Archived from the original on August 17, Retrieved January 25, Archived from the original on December 24, Archived from the original on April 7, Shaff, Reed ed.

Archived from the original on January 16, Retrieved December 20, Supersite for Windows. Retrieved January 13, August 17, August 11, September 22, Retrieved January 21, November Archived from the original on December 8, Retrieved February 4, Archived from the original on January 23, Retrieved January 22, Archived from the original on August 9, Retrieved January 30, Archived PDF from the original on March 27, Retrieved February 12, Archived PDF from the original on August 24, Retrieved March 27, Archived PDF from the original on August 4, June 6, Archived from the original on February 19, Retrieved November 11, Archived from the original on December 20, March 16, Retrieved February 9, July 23, November 6, Archived from the original on February 12, Archived from the original on December 1, Archived from the original on June 19, Retrieved February 11, Retrieved January 26, May 8, Retrieved January 20, December 14, April 12, Archived from the original on December 28, Retrieved January 19, Retrieved January 23, Archived PDF from the original on August 30, Archived from the original on February 3, Retrieved February 1, Archived from the original on March 28, October Tom's Hardware.

Retrieved March 23, Archived from the original on January 31, Retrieved January 31, May 6, Archived from the original on February 5, August 5, Retrieved February 5, May 17, Archived from the original on January 18, July 31, Archived from the original on September 29, Retrieved January 14, Archived from the original on March 31, Archived from the original on January 7, September 6, Archived from the original on April 24, Retrieved April 7, Archived PDF from the original on August 29, Retrieved January 15, Archived from the original on June 25, Archived from the original on June 12, Archived from the original on June 16, Office Professional Plus is available through Volume Licensing only.

May 15, Archived from the original on October 20, To determine whether an Office installation is a volume licensed version, check the Office installation disc to see whether it contains a folder named Admin. If the Admin folder exists, the disk is a volume license edition. Archived from the original on May 12, Retrieved April 30, Archived from the original on May 21, Dennis Publishing.

Archived from the original on January 27, Retrieved April 28, PC Advisor. Archived from the original on March 22, Archived from the original on June 3, Archived from the original on May 31, Four Questions to Ask when Choosing". Archived from the original on June 10, Archived from the original on April 21, Archived from the original on May 22, Archived from the original on April 22, The Telegraph.

Telegraph Media Group. Channel Pro. October 1, Archived from the original on April 13, June 22, Laptop Magazine. Here's a chart". Garmon, Jay ed. Notebook Review. Archived from the original on April 2, NPD Group Blog. NPD Group. Archived from the original on July 17, Business Insider. Office XP has a streamlined, flatter appearance compared to previous versions of Office.

According to Microsoft, this change involved "removing visually competing elements, visually prioritizing items on a page, increasing letter spacing and word spacing for better readability, and defining foreground and background color to bring the most important elements to the front. Excel and Word introduce smart tags , commands for specific types of text including addresses , calendar dates , personal names , telephone numbers , ticker symbols , or tracking numbers in documents.

Excel and Word support extensible smart tags that allow developers and organizations to display custom commands related to specific information. The smart tags used by Word are also available in Outlook if the former is configured as the default e-mail editor. The AutoCorrect and Paste Options commands in previous versions of Office have been updated to include smart tags that are shared among all Office XP programs. The AutoCorrect smart tag provides individual options to revert an automatic correction or to prohibit an automatic correction from occurring in the future, and also provides access to the AutoCorrect Options dialog box.

After the release of Office XP, Microsoft provided a repository for downloadable smart tags on its website. Office XP introduces a task pane interface that consolidates popular menu bar commands on the right side of the screen to facilitate quick access to them. Word , for example, includes a task pane dedicated to style and formatting options. Users can switch between open task panes through the use of back and forward buttons; a drop-down list also presents specific task panes to which users can switch.

The default Startup task pane is automatically available when users launch an Office XP program and presents individual commands to open an existing file, create a new blank file or one from a template , add a network location, or open Office Help.

The Search task pane includes individual Basic and Advanced modes and allows users to query local or remote locations for files.

The Basic mode allows users to perform full-text searches , while the Advanced mode provides additional file property query options. The Office Clipboard has been redesigned as the Clipboard task pane across all Office XP programs and can accommodate up to 24 clipboard items compared to 12 in Office Clipboard items provide a visual representation to help users distinguish different types of content.

Access and Excel support exporting and importing XML. Users can also save Excel workbooks as XML spreadsheets. Office XP introduces handwriting recognition in all Office programs, allowing users to write with a mouse or stylus instead of entering text by typing on a keyboard. Once installed, handwriting functionality is also available in Internet Explorer 5 and Outlook Express 5 or later. The downloadable Tablet Pack for Office XP provided an extension for Windows Journal to reuse notes as Outlook items and to import meeting information from Outlook into notes.

Speech recognition based on Microsoft Research technology is available for all Office XP programs, allowing users to dictate text into active documents, to change document formatting, and to navigate the interface by voice.

The speech recognition feature encompasses two different modes: Dictation, which transcribes spoken words into text; and Voice Command, which invokes interface features. Speech recognition can be installed during Office XP setup or by clicking the Speech option in the Tools menu in Word When installed, it is available as a Microphone command on the Language toolbar that appears in the upper-right corner of the screen lower-right corner in East-Asian versions of Office XP.

When launched for the first time, speech recognition offers a tutorial to improve recognition accuracy, which begins by providing instructions to adjust the microphone for optimal performance. Users can configure speech recognition settings, including pronunciation sensitivity in voice command mode, accuracy and recognition response time in dictation mode, and microphone settings through the Speech control panel applet. The Regional and Language Options applet provides Language toolbar and additional settings.

With Office XP, Microsoft incorporated several features to address reliability issues observed in previous versions of Office:. Additionally, all Office XP programs provide options for users to digitally sign documents.

When upgrading from a previous version of Office, Office XP retains the user's previous configuration. The Custom Installation Wizard can prohibit the installation, use, or uninstallation of programs or features such as the Run from Network and Installed on First Use setup options. Finally, the Custom Maintenance Wizard has been updated to provide customization options to configure Office XP including user preferences and security settings.

In an effort to curtail software piracy , Microsoft incorporated product activation technology into all versions of Office XP to prohibit users from installing a single copy of the software in a manner that violates the end-user license agreement EULA.

The EULA allows a single user to install one copy each on a primary device and a portable device such as a laptop.

Users who make substantial hardware changes to an Office XP device may need to reactivate the software through the Internet or by telephone. Product activation does not require personally identifiable information. Office XP introduced an optional subscription-based activation model that allowed consumers to annually license the product and receive incremental updates at a reduced price when compared with the cost of a full retail version.

Microsoft originally intended to deliver the activation model to United States customers after the retail availability of Office XP on May 31, , but later decided to make it available to consumers in "a few select locations" instead, citing a more cautious delivery approach.

A new "Ask a Question" feature appears in the top-right corner of all Office XP programs and allows users to type natural language questions and receive answers without opening the Office Assistant "Clippy" or Office Help. Additionally, Office Help has been updated to aggregate and display content from the Internet in response to a query. The Office Assistant is now disabled by default and only appears when Help is activated.

The component products were packaged together in various suites. Some of these editions were available as retail packages in either full or upgrade versions, others as full OEM versions for inclusion with new PCs, and still others as volume license versions that required no activation. All editions provided the core components of Word, Excel, and Outlook, and all editions except the Small Business edition provided PowerPoint. Microsoft Office XP received mixed to positive reviews after its release.

CNET praised the new collaboration and data recovery features, and stated that Office XP offered a "host of incremental improvements" over its predecessor, Office , but ultimately concluded that "most enhancements and additions are better suited for groups than individuals. While most assessments of Office XP were positive, the speech recognition feature was frequently criticized due to its inaccuracy and lack of advanced functionality.

CNET regarded it as "especially lame" because of its inability to recognize text editing commands such as "select the sentence" and because it required users to manually switch between command and dictation modes. From Wikipedia, the free encyclopedia. Version of Microsoft Office suite. These applications make up the Standard edition. Windows NT 4. List of languages. Main article: Smart tag Microsoft. Intel Pentium III. Hardware accelerated video card or MMX processor.

An audio output device and microphone are required for speech recognition. Collaboration features require Office 97 or later Internet access is required for product activation and online functionality. Touchscreen for handwriting functionality. News Center. May 31, Retrieved February 25, Download Center. March 30, Archived from the original on January 5, Office Support. May 30, Archived from the original on December 1, Archived from the original on March 7, Retrieved April 9, August 6, Archived from the original on April 14, Retrieved February 26, Windows IT Pro.