Ultimately you understood that two software options don't work one into another. You had found invalidity of your file. You have a way that you could able to copy your files from MS Office into your 4GB pen drive and carry your files certainly.
Open your Office document page then open a new file and fix your pen drive into your CPU USB port and save your copied files into your Office software. How to open Office files in Office ? Go To Solution. Best Answer. Hello Nadeem. After editing when you save the file it will ask you the format and it will look like this. About taashi. Questions 6. Answers 6. Best Answers 3.
Vote Up 0 Vote Down. Yes, This is the only way to open Office projects in Office Be happy. Unsupported graphics, object, and ActiveX features can cause the following compatibility issues, leading to a significant loss of functionality.
Any effects on this object will be removed. Any text that overflows the boundaries of this graphic will appear clipped. What it means Beginning with Excel , you can use special effects, such as transparent shadows that are not supported in Excel The special effects will be removed.
Also, beginning with Excel , when you insert text in a shape that is wider than the shape, the text displays across the boundaries of the shape. In Excel , this text is truncated. To avoid truncated text, you can adjust the size of the shape for a better fit.
What to do In the Compatibility Checker, click Find to locate the objects that have special effects applied so that you can remove those effects as needed. What it means Embedded objects that are created in Excel and later cannot be edited in Excel What to do In the Compatibility Checker, click Find to locate the objects that contain text that will not be editable, and then make the necessary changes.
Uninitialized ActiveX controls cannot be transferred to the selected file format. The controls will be lost if you continue. What it means If a workbook contains ActiveX controls that are considered to be Unsafe for Initialization UFI , they are lost when you save the workbook to an earlier Excel file format.
What to do If you open a workbook that contains uninitialized ActiveX controls, and the workbook is set to high security, you must first use the Message Bar to enable them before they can be initialized.
One or more objects in this workbook such as shapes, WordArt, or text boxes may allow text to overflow the object boundaries. Earlier versions of Excel do not recognize this option and will hide overflowing text. What it means Beginning with Excel , you can display text boxes on objects such as shapes and display the text beyond the boundaries of those objects. In Excel , text that overflows the boundaries of an object will not be visible.
What to do In the Compatibility Checker, click Find to locate the text box that contains text that overflows the boundaries of the shape, and then make the necessary changes to keep the text within the boundaries, and then turn the option to overflow text off Right-click the shape, Format Shape , Text Box category, Allow text to overflow shape check box.
This workbook contains Textboxes with text formatting not available in earlier versions of Excel. The text in the Textboxes will appear differently in the earlier versions of Excel. What it means Beginning with Excel , you can use a text box on objects such as shapes that displays more than one column of text.
In Excel , the text will be displayed but in a different format. What to do In the Compatibility Checker, click Find to locate the text box that displays more than one columns of text, and then make the necessary changes to display the text in one column only Right-click the shape, Format Shape , Text Box category, Columns button. Unsupported customization features can cause the following compatibility issues, leading to a minor loss of fidelity.
These custom features will not be available in earlier versions of Excel. What it means Because the Ribbon interface that was introduced with Office is very different from the menus and toolbars in Excel , any Quick Access Toolbar customizations that were made in Excel and later are not available in Excel What to do In Excel , you can add similar custom commands to toolbars and menus. The following unsupported feature can cause compatibility issues, leading to a minor loss of fidelity.
This workbook will be read-only and shared workbook features will not be available when someone opens it in an earlier version of Excel by using a file converter. To allow users to continue using the workbook as a shared workbook in earlier versions of Excel, you must save it in the file format of the earlier versions.
What it means If you turn on the Allow changes by more than one user What to do Save the workbook to the Excel file format, and then work with that workbook in Compatibility Mode. When you open a workbook that was created in Excel , and you no longer plan for anyone to work on this workbook in this earlier version, you can convert the workbook to the current XML-based file format.
When you convert to the current file format, you will have access to all new and enhanced features and functionality that newer versions of Excel offer, and the file size will generally be smaller. Convert the workbook to the current file format When you convert an Excel workbook, it is replaced with a copy of the workbook in the current file format of your choice.
After the workbook is converted, it is no longer available in the original file format. Note The workbook is opened in Compatibility Mode. In Excel , click the Office button.
Tip If you do not want to see this message about converting workbooks, select the Do not ask me again about converting workbooks. To work in the current file format, click Yes to close and reopen the workbook. Save the workbook in the current file format If you want to keep a copy of the workbook in the original file format, instead of converting the workbook, you can save a copy of the workbook in one of the current file formats.
In the File name box, accept the suggested name or type a new name for the workbook. If the workbook contains macros that you want to retain, and you want to save the workbook as a template, click. When you open a workbook in Excel or later that was created in Excel , some features of the earlier version of Excel are not supported in the workbook.
Unsupported features have either been replaced by new features and functionality, or they have been removed because they were rarely used.
Tip If features are not available on the ribbon but are still available in Excel, you can still use those features by adding them to the Quick Access Toolbar or the ribbon. The following Excel features may function differently, have been removed, or are not available on the ribbon. You can use the AutoFormat feature to apply one of several autoformats to quickly format a range of data.
Style galleries for tables, cells, and PivotTables provide a set of professional formats that can be applied quickly. You can choose from many predefined styles or create custom styles as needed. Styles replace AutoFormat as the simplest way to apply formatting to a range of cells. You can also still use the AutoFormat command, but you have to add the command to the Quick Access Toolbar first.
You can create an Excel list to make it easier to manage and analyze groups of related data in a worksheet. Excel lists are now referred to as Excel tables to match this feature in other Microsoft Office programs, such as Word and PowerPoint. You can use an insert row a special row in Excel lists to quickly add a new row of data at the end of a list. The insert row is no longer available.
To add new rows to a table, press TAB, or type, paste the data that you want to include just below a table. You can also insert rows to include additional rows of data. When you create a table, a defined name for the same range is created at the same time. This name can be used to reference the table in formulas that use the new, structured referencing feature. Names that are used for lists in earlier versions of Excel might not meet the requirements for range names in Excel and later, and therefore cannot be used for referencing the table in formulas that use the new structured referencing feature.
To use table names in structured references, you must change the defined names. Two-way synchronization of Excel tables with SharePoint lists is no longer supported. When you export table data to a SharePoint list, you can only create a one-way connection to the data in the SharePoint list.
With a one-way connection to the data in the SharePoint list, changes that are made to the data in the SharePoint list can be incorporated in Excel and later. When you refresh the table data in Excel and later, the latest data from the SharePoint site overwrites the table data on the worksheet, including any changes that you made to the table data.
In Excel and later,, you can no longer update a SharePoint list to include changes that you make to the table data in Excel, after that data has been exported. To preserve a two-way connection, you have to keep the workbook in Excel file format instead of converting it to the Excel and later file format. For more information about how to replace or work around an unsupported feature, see the following articles:. Define and use names in formulas.
Full row and full column references that are used in a workbook can include data in cells that are located within the row and column limit of Excel Full row and full column references automatically take into account the cells in the larger grid size of Excel and later.
Converting a workbook from an earlier version of Excel to the Excel and later file format can cause problems when full row or column references are used in that workbook, and data that was not meant to be included in the references has been entered in cells that are beyond the row and column limit of the earlier version of Excel. Specific names that use a combination of letters and numbers such as USA1 , FOO , and MGR4 can be defined and used in formulas in Excel because they do not conflict with cell references.
With a new limit of 16, columns, the columns in Excel and later extend to column XFD. In addition, Excel and later reserves names that start with XL for internal use. When incompatible names are found when you convert a workbook from an earlier version of Excel to the Excel and later file format, you will be alerted about the conflict.
External workbook references and functions that take string references such as INDIRECT are not updated — these references and functions must be changed manually. VBA code that references incompatible names will not work and must be updated. You create a chart by clicking the chart type that you want on the ribbon Insert tab, Charts group. After creating the chart, you can use the Chart Tools to modify and format the chart.
When an existing chart sheet that contains data is selected, you can press F11 to create a chart sheet with the same data. Pressing F11 when an existing chart sheet that contains data is selected creates a new chart sheet without data. You can only change the rotation of a 3-D chart by specifying settings in the 3-D Rotation category in the Format Chart Area dialog box.
Charts with pattern fills that were created in an earlier version of Excel appear the same when they are opened in Excel and later, but you cannot use the pattern fills in other chart elements.
You can use the Size with window command to automatically resize charts that are located on chart sheets when you change the size of the window. Instead of the Size with window command, you can use the Zoom to Selection command to achieve similar results.
By default, a copied chart is pasted in a Word or later document or PowrPoint or later presentation as an object that is linked to the Excel chart. You can change the way that a copied chart is pasted by clicking the Paste Options button that is displayed when you paste the chart, and then pasting the chart as a picture or a whole workbook.
When you create a chart in Word or later, you get a worksheet with sample data instead of the data in the selected Word table.
To plot the Word table data into the new chart, you have to copy that data to the worksheet, replacing the existing sample data. You can specify printed chart size and scaling options on the Chart tab of the Page Setup dialog box. The Chart tab is available only when a chart is selected File menu, Page Setup command. The printed chart size and scaling options are no longer available on the Chart tab of the Page Setup dialog box. You can add data to a chart by selecting the data in the worksheet and dragging it onto the chart.
Shapes that are drawn in earlier versions of Excel cannot be grouped with shapes that are drawn in Excel and later, even when the shapes are upgraded to the current version. You cannot select shapes that are created in different versions of Excel at the same time.
Shapes that are created in different versions of Excel are layered on top of current shapes. Much like shapes, charts that are created in Excel and later cannot be layered over dialog sheets that are created in earlier versions of Excel, and you cannot view charts that are layered underneath these dialog sheets. To select the current charts, use the chart element selection box Chart Tools , Format tab, Current Selection group.
To select hidden charts or shapes that were created in an earlier version of Excel, you must first add the Select Multiple Objects command to the Quick Access Toolbar or to a custom group on the ribbon. For more information about how to replace or work around an unsupported feature, see the following article:.
Create a chart from start to finish. Names used for PivotTable reports in earlier versions of Excel might not meet the requirements for range names in Excel and later, and therefore cannot be used for referencing a table in formulas that use the new structured referencing feature. To use PivotTable report names in structured references, you must change the defined names.
Calculated members that are defined in OLAP cubes are no longer displayed by default in PivotTable reports, but calculated measures calculated members in the Measures dimension are displayed by default.
When you convert a workbook from an earlier version of Excel to the Excel and later file format, only the filtering options that are available in Excel PivotTable reports will be available in Excel and later PivotTable reports, because the earlier versions of SQL Server Analysis Services do not support sub-selects. By using this feature, you can add a hierarchical data structure to relational data so that the relational data can be viewed in PivotTable reports and stored in a separate file.
To create PivotTable reports that are based on relational data, you can connect to the relational data directly, or you can import the relational data into an Excel workbook. Some familiar features are available only when you use the wizards, such as server-defined page fields, the option to optimize memory, the ability to explicitly create a PivotTable report based on another PivotTable report, and multiple consolidation ranges. PivotTable reports preserve customization of items such as custom labels and item formatting even when those items are temporarily not visible in the PivotTable report.
When you convert a workbook from an earlier version of Excel to the Excel and later file format, the custom labels and item formatting are applied when you collapse fields. Custom labels are always available in the workbook, even when fields are removed from the PivotTable reports, and then added again at a later time. Pivot data in a PivotTable or PivotChart report.
Create a PivotTable to analyze worksheet data. Create a PivotChart. Support for the following file formats has been removed from Office and later. You will not be able to open or save workbooks in these file formats. File formats that are not supported in Excel and later. Office and later no longer stores Excel-specific feature information in this file format. You can open a file in this format, preserving any Excel-specific features that were created in an earlier version of Excel.
However, you can save such a file or any other workbook in this file format for publishing purposes only. To make sure that an Excel or later workbook does not have compatibility issues that cause a significant loss of functionality or a minor loss of fidelity in an earlier version of Excel, you can run the Compatibility Checker.
The Compatibility Checker finds potential compatibility issues and helps you create a report so that you can resolve them. Important When you work on a workbook in Compatibility Mode, where the workbook is in Excel file format. Click the Check for Issues button, and then click Check Compatibility. To check the workbook for compatibility every time that you save it, select the Check compatibility when saving this workbook check box.
To create a report in a separate worksheet of all the issues that are listed in the Summary box, click Copy to New Sheet. Tip If available, you can click Find to locate the issues in the worksheet or Fix to resolve simple issues. For more complex issues, click Help for more information. You can always ask an expert in the Excel Tech Community or get support in the Answers community. Excel formatting and features that are not transferred to other file formats. Save an Excel workbook for compatibility with earlier versions of Excel.
Worksheet compatibility issues. 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! One or more cells in this workbook contain a sparkline. Sparklines will not be saved. Minor loss of fidelity. You can no longer duplicate chart sheets that contain data by pressing F You cannot use the mouse to change the rotation of a 3-D chart. Instead of pattern fills in chart elements, you can use picture and texture fills. A text box is automatically created when you click anywhere on a chart and start typing.
You cannot create a text box when you click anywhere on a chart and start typing. To add a text box on a chart, use the Insert Text Box command. By default, a copied chart is pasted as a picture in a Word document or PowerPoint presentation. A table in Word or later cannot be used as data for a new chart. You can no longer drag data from a worksheet to a chart. You can use other methods to add data to a chart.
You can drag data points on a chart and change their source values on the worksheet. Dragging data points to change the source values on the worksheet is no longer supported. Shapes are drawn in a format that differs from the shape format that is used in Excel Custom labels and item formatting are lost when you collapse fields.
Internet access is also required to access documents stored on OneDrive, unless you install the OneDrive desktop app. You should also connect to the internet regularly to keep your version of Office up to date and benefit from automatic upgrades. To reactivate your Office applications, reconnect to the internet. Documents that you have created belong fully to you. If you cancel your subscription or it expires, you can still access and download all your files by signing in to OneDrive directly using the Microsoft account you used to set up Microsoft You do lose the additional storage that comes with your subscription, so you must save your files elsewhere or buy more OneDrive storage if your OneDrive account exceeds the free storage quota.
If you purchase an auto-renew subscription, your subscription starts when you complete your purchase. You can purchase auto-renew subscriptions from Microsoft If you purchase a pre-paid subscription, your subscription starts when you activate your subscription and land on your My Account page. You can purchase pre-paid subscriptions from a retailer or reseller, or a Microsoft support agent. If you have an active Microsoft Family subscription, you can share it with up to five members of your household six total.
When you use cloud-based services, your IT infrastructure resides off your property off-premises , and is maintained by a third party hosted , instead of residing on a server at your home or business on-premises that you maintain.
With Microsoft , for example, information storage, computation, and software are located and managed remotely on servers owned by Microsoft. Many services you use every day are a part of the cloud—everything from web-based email to mobile banking and online photo storage.
Upgrade from Word to Microsoft Still using Word ? Bring out your best writing with Word in Microsoft See options for home. See options for work. Office is now retired Do your best writing with the most up-to-date version of Word. Upgrade to Microsoft today. See plans and pricing for Microsoft Shift your business to Microsoft Bring out your best writing Go from blank page to polished document in no time with the Researcher and Editor tools. Coauthor with anyone anywhere Invite others to edit and comment, manage access, and keep track of versions.
Take Word on the go Review and edit files at work, home, or anywhere in between with mobile apps.
0コメント