Updating links between excel and powerpoint devexpress gridview rowupdating error
Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange How can I hyperlink from Power Point to Excel, linking to a specific tab and named range or cell and make it stick?
One disadvantage is that the original spreadsheet file needs to stay in the same location. And since it relies on the link to the original spreadsheet, it’s not so useful if you need to distribute the presentation to people who don’t have access to that location.
This works okay, but all it really does is convert the data to a simple table in Power Point.On Home tab of the Ribbon, click the down arrow beneath the “Paste” button, and then choose the “Paste Special” command from the dropdown menu. And it’s here where you’ll find the only functional different in the processes of linking or embedding a file. Whichever option you choose, you’ll next select the “Microsoft Excel Worksheet Object” in the box to the right, and then click the “OK” button.If you want to your spreadsheet, choose the “Paste Link” option instead. And you’ll see your Excel sheet (or the cells you selected) in your Power Point presentation.There are some distinct advantages to embedding, though.For example, if you’re distributing that presentation to people who might not have access to the original Excel sheet, or if the presentation needs to show that Excel sheet at a specific point in time (rather than getting updated), embedding (and breaking the connection to the original sheet) makes more sense.