Article shows in 3 easy steps with screenshots how to add, attach or insert any file like PDF of Word document to a spreadsheet in Excel 2013/2016. Is there a VBA that can be used to embed two page Pdf document in excel. With out having to double click the attached object to view the entire document.
One of the advantages of doing the last Office 2016 product review is that I can leverage work others have done to save you, the reader, some redundant explanation. So if you haven’t yet, check out the reviews of,. Much of what you’ll read about in those apps applies to, too: Mac-specific features like multi-touch gestures, full screen support, Retina graphics, a cleaned-up and easily-hidden ribbon, a fixed task pane that replaces floating palettes for formatting, integrated support for OneDrive, and excellent cross-platform file compatibility. You can read more about these features in the above-mentioned reviews; they work just the same way in the new Excel. (As with the other apps, you can only presently get Excel 2016 if you’re an Office 365 subscriber.) What else is new When you launch Excel 2016, you’ll be greeted by Excel’s clean new appearance.
You can choose from a colored header (new in 2016) or the usual gray header from previous releases. Workbooks with multiple tabs get a much cleaner tab bar, losing the fake 3D appearance. Colored tabs are now colored with a thin bar, instead of a gradated fill on the entire tab, making it easier to read tab names. Overall, I found the new interface pleasant and easier to use than in older versions of Excel.
Excel includes the Smart Lookup feature found in other Office apps. Smart Lookup uses Bing to show contextual information for a highlighted word—while this is undoubtedly useful in Word, I didn’t really find myself using it much while working on spreadsheets. But if you suddenly need to look up everything there is to know about the word “amortization,” Smart Lookup is ready for you. So what’s new and unique to Excel 2016?
Quite a few things, starting with the removal of the Standard and Formatting toolbars. While you could hide these in Excel 2011, they’re completely gone—replaced by the task pane—in Excel 2016. I don’t miss them at all, as they were redundant and took up screen space. Also new is greatly improved sharing.
![2016 2016](/uploads/1/2/5/4/125407509/909532158.jpg)
Save your file to OneDrive, and you can then use a sharing button to invite people via their email address, copy a link you can then email to others, or send the workbook as either a PDF or native workbook attachment. Recipients can (assuming you grant permission) edit your file, even if they don’t own Excel, through Microsoft’s web-hosted Excel app. Fans of pivot tables will find a new slicer tool that greatly increases the usability of pivot tables. A slicer is a way to limit the data you see in a pivot table. In a pivot table showing years of sales by salesperson, for example, you can use slicers to restrict the table to one or more years, or to one or more salespeople. Slicers let you limit what you see in a pivot table; you can add one or more to really refine what you see. Here, only data from 2012, 2013, and 2015 is visible.
Another “new” feature is the inclusion of the Analysis Toolpak add-on. I say new in quotes because while new to Excel 2016, long-time Excel vets will remember the Analysis Toolpak from the pre-OS X days. If you need to do complex statistical and/or engineering analysis—think Anova, Fourier Analysis, Regression, etc.—you’ll find the Analysis Toolpak invaluable. Also included are a number of formulas that were previously found only in Excel 2013 for Windows, improving cross-platform compatibility. Again in the interest of cross-platform compatibility, many Excel for Windows shortcuts now work on the Mac, which is quite useful if you regularly work on both platforms.
Excel also makes charting easier by analyzing your data and letting you select a recommended chart from a convenient drop-down menu. Select the data you want graphed, click the Recommended Charts button, then browse the mini chart previews to find the one that best matches what you’re trying to say. Excel 2016 helps you pick the right chart by analyzing your data and presenting a list of charts you can use to visualize that data. What’s gone If you’re a serious user of Excel’s macro facilities, you are in for a big letdown: Excel’s 2016 support for macros is. While you can create and record macros, the macro editor is crippled: there’s no way to insert procedures, modules, etc. About all you can do is hand-edit a recorded macro. Further, you can’t create custom menu commands, as you could in prior versions of Excel.
(Microsoft details is Visual Basic support in a ). In short, if you need macros, stick to Excel 2011. After the great progress made with macros in the 2011 release, this is a real letdown. Assuming the macro issue doesn’t affect you, the only other real problem I have with Excel 2016 is the loss of customizability of keyboard shortcuts and menus. In older Excel versions, you could easily customize which commands show on which menus, and even create entirely new menus containing just the commands you specify. This dialog in Excel 2011 allowed you to easily customize Excel’s menus and commands—even adding a new menu to the menu bar, if you desired.
You could also assign one or more keyboard shortcuts to any Excel command, including commands that you can’t program via OS X’s keyboard shortcut interface. The dialog that handles all of this customization is missing from Excel 2016; if you don’t like what Microsoft gave you for menus and certain shortcuts, you’re stuck with them. A related issue is that some familiar—and useful—shortcuts are now changed or gone. Control-I and Control-K used to insert and delete rows or columns; now you must use three fingers (Shift-Command-Equals) to add a row, and Command-Minus to remove a row. You also used to be able to Option-click a row or column to quickly add a new blank row or column; this no longer works. If you use the keyboard a lot, you’ll want to open Excel’s help and search “keyboard shortcuts,” where you’ll find a huge list of shortcuts.
Bottom line If you’re an Excel user who doesn’t rely on macros, and doesn’t need to customize your menus and commands, Excel 2016 has a lot going for it. The new interface is pleasant, the cross-platform features are a welcome addition, the performance is very good, and the Mac-specific features make Excel feel as native as any other Mac app. But if you do need macros and customizability, then you’re going to have to stick to Excel 2011and that’s too bad, because Excel 2016 is a solid release in every other regard.
Excel 2016 for Mac PowerPoint 2016 for Mac Word 2016 for Mac Office 2016 for Mac Word for Mac 2011 Excel for Mac 2011 PowerPoint for Mac 2011 When you use Office, you have several ways to share information among applications. Copying and pasting is one way, but you can also link information so that it is updated automatically or embed the information so that it is updated only when you manually update it by opening the file. You can also link to a portion of a file — for example, a few cells in an Excel sheet — by using a linked object. Advantages and disadvantages of linking vs. Embedding Linking Embedding Updates information automatically Makes it easy to open the application that the embedded information was created in Keeps file sizes small Results in file sizes that are larger than those with linked information Requires both files to be accessible to view the information Requires both files to be accessible to update the information, but not to view it Is not suitable if you want to distribute the file online Is suitable if you want to distribute the file online because all the information is contained in one file. If you maintain data in an Excel file and related information in a Word file, you can link the information to make updating easier.
For example, suppose that you want to link the latest sales returns to your monthly status report. The status report is a Word document, and the sales returns are on an Excel sheet.
By linking the document and the sheet, the status report updates automatically whenever the sales returns are updated. Or, you might want to insert instructions from a Word document into several Excel files.
By using a link, you can update the instructions, and the updates appear in all the Excel files. Click where you want to insert the link. On the Insert menu, click Object, and then click From File. Locate and click the file that you want to link to, then click Options. Select the Link to File check box. If you want the two files to remain connected but you do not want the main file to update when the other file is changed, you can embed the information.
For example, if you don't want the status report to change when the Excel sheet changes or you do not want the Excel sheet to change when the instructions change, you can embed information. Because the information is totally contained in one file, embedding is useful when you want to distribute an online version of your file to people who don't have access to the embedded file.
Click where you want to embed the file. On the Insert menu, click Object, and then click From File. Select the file you want, and then click Options.
If you embed an Excel sheet, it must be the first sheet in the workbook. Clear the Link to File check box. You can link to part of a file. For example, in a monthly status report, you might want to link to a specific range of cells from an Excel sheet instead of the entire sheet. For example, you might want to link to specific instructions from a Word document instead of the entire document. Select the information that you want to paste — for example, a range of cells on an Excel sheet.
On the Edit menu, click Copy. Switch to the other file, and then click where you want the information to appear. On the Edit menu, click Paste Special, and then click Paste link. In the As box, click the type of object, for example, Microsoft Excel Worksheet Object, and then click OK. If you want the two files to remain connected but you do not want the main file to update when the other file is changed, you can embed the information. For example, suppose that you want to embed the latest sales returns in your monthly status report.
The status report is a PowerPoint presentation, and the sales returns are on an Excel sheet. By embedding the sheet in a presentation, the two files remain connected. Click where you want to embed the file.
On the Insert menu, click Object, and then click From file. Locate and click the file that you want to embed. If you embed an Excel sheet, it must be the first sheet in the workbook. Click Insert, and then click OK. If you can't see the information in the embedded file, drag a sizing handle until you see the file contents.
You can embed part of a file. For example, in a monthly status report, you might want to embed a specific range of cells from an Excel sheet instead of the entire sheet. Select the information that you want to paste — for example, a range of cells on an Excel sheet. On the Edit menu, click Copy. Switch to the other file, and then click where you want the information to appear.
On the Edit menu, click Paste Special. In the Paste As box, click the type of object, for example, Microsoft Excel Worksheet Object, and then click OK. If you maintain data in an Excel file and related information in a Word file, you can link the information to make updating easier. For example, suppose that you want to link the latest sales returns to your monthly status report. The status report is a Word document, and the sales returns are on an Excel sheet. By linking the document and the sheet, the status report updates automatically whenever the sales returns are updated.
Or, you might want to insert instructions from a Word document into several Excel files. By using a link, you can update the instructions, and the updates appear in all the Excel files. Click where you want to insert the link. On the Insert menu, click Object, and then click From File. Select the file that you want to link to, then click Options.
Select the Link to File check box. If you want the two files to remain connected but you do not want the main file to update when the other file is changed, you can embed the information. For example, if you don't want the status report to change when the Excel sheet changes or you do not want the Excel sheet to change when the instructions change, you can embed information. Because the information is totally contained in one file, embedding is useful when you want to distribute an online version of your file to people who don't have access to the embedded file.
Click where you want to embed the file. On the Insert menu, click Object, and then click From File. Select the file that you want to embed, and then click Options. If you embed an Excel sheet, it must be the first sheet in the workbook. You can link to part of a file. For example, you might want to link to a specific range of cells from an Excel sheet instead of the entire sheet. Select the information that you want to paste — for example, a few sentences in a Word document.
On the Edit menu, click Copy. Switch to the other file, and then click where you want the information to appear. On the Edit menu, click Paste Special, and then click Paste link. In the As box, click the type of object, for example, Microsoft Word Document Object, and then click OK. If you maintain data in an Excel file and related information in a Word file, you can link the information to make updating easier. For example, suppose that you want to link the latest sales returns to your monthly status report. The status report is a Word document, and the sales returns are on an Excel sheet.
By linking the document and the sheet, the status report updates automatically whenever the sales returns are updated. Or, you might want to insert instructions from a Word document into several Excel files.
By using a link, you can update the instructions, and the updates appear in all the Excel files. Click where you want to insert the link. On the Insert menu, click Object, and then click From File. Locate and click the file that you want to link to.
If you want the two files to remain connected but you do not want the main file to update when the other file is changed, you can embed the information. For example, if you don't want the status report to change when the Excel sheet changes or you do not want the Excel sheet to change when the instructions change, you can embed information. Because the information is totally contained in one file, embedding is useful when you want to distribute an online version of your file to people who don't have access to the embedded file.
Click where you want to embed the file. On the Insert menu, click Object, and then click From File. Locate and click the file that you want to embed.
If you embed an Excel sheet, it must be the first sheet in the workbook. You can link to part of a file. For example, in a monthly status report, you might want to link to a specific range of cells from an Excel sheet instead of the entire sheet. For example, you might want to link to specific instructions from a Word document instead of the entire document. Select the information that you want to paste — for example, a range of cells on an Excel sheet. On the Edit menu, click Copy.
Switch to the other file, and then click where you want the information to appear. On the Edit menu, click Paste Special, and then click Paste link. In the As box, click the type of object, for example, Microsoft Excel Worksheet Object, and then click OK.
If you want the two files to remain connected but you do not want the main file to update when the other file is changed, you can embed the information. For example, suppose that you want to embed the latest sales returns in your monthly status report. The status report is a PowerPoint presentation, and the sales returns are on an Excel sheet. By embedding the sheet in a presentation, the two files remain connected. Click where you want to embed the file.
On the Insert menu, click Object, and then click Create from file. Locate and click the file that you want to embed. If you embed an Excel sheet, it must be the first sheet in the workbook.
Click Insert, and then click OK. If you can't see the information in the embedded file, drag a sizing handle until you see the file contents. You can embed part of a file.
For example, in a monthly status report, you might want to embed a specific range of cells from an Excel sheet instead of the entire sheet. Select the information that you want to paste — for example, a range of cells on an Excel sheet. On the Edit menu, click Copy. Switch to the other file, and then click where you want the information to appear.
On the Edit menu, click Paste Special. In the Paste As box, click the type of object, for example, Microsoft Excel Worksheet Object, and then click OK. If you maintain data in an Excel file and related information in a Word file, you can link the information to make updating easier. For example, suppose that you want to link the latest sales returns to your monthly status report.
The status report is a Word document, and the sales returns are on an Excel sheet. By linking the document and the sheet, the status report updates automatically whenever the sales returns are updated. Or, you might want to insert instructions from a Word document into several Excel files. By using a link, you can update the instructions, and the updates appear in all the Excel files. Click where you want to insert the link.
On the Insert menu, click Object, and then click From File. Locate and click the file that you want to link to. If you want the two files to remain connected but you do not want the main file to update when the other file is changed, you can embed the information.
For example, if you don't want the status report to change when the Excel sheet changes or you do not want the Excel sheet to change when the instructions change, you can embed information. Because the information is totally contained in one file, embedding is useful when you want to distribute an online version of your file to people who don't have access to the embedded file. Click where you want to embed the file. On the Insert menu, click Object, and then click From File.
Locate and click the file that you want to embed. If you embed an Excel sheet, it must be the first sheet in the workbook. You can link to part of a file. For example, you might want to link to a specific range of cells from an Excel sheet instead of the entire sheet. Select the information that you want to paste — for example, a few sentences in a Word document. On the Edit menu, click Copy. Switch to the other file, and then click where you want the information to appear.
On the Edit menu, click Paste Special, and then click Paste link. In the As box, click the type of object, for example, Microsoft Word Document Object, and then click OK.