![]() ![]() In the Dimensions section, type a width and height for the viewer, in pixels. If you want to specify a cell to be selected when the blog page opens, check the Always start with this cell selected box, and then click the cell you want in the preview. For example, if you embed a mortgage calculator, you might want to enable typing so that people can fill out the loan term, loan amount, and other variables. If you allow typing, changes people make in the cells in your blog will not be saved in the original workbook. If you allow sorting and filtering, your blog readers will be able to sort, filter, and expand or collapse the tables or PivotTables in the workbook. In the Interaction section, choose how you want to allow people to interact with the workbook. In the Appearance section, check the boxes for the options you want. For information about named ranges and named items in Excel workbooks see Define and use names in formulas. Show the entire workbook, or show a chart, a named range, PivotTable, or table. In the What to show box, click what you want to show in your blog. ![]() In OneDrive, right-click the workbook, and then click Embed.Ĭlick Generate, and then click Customize how this embedded workbook will appear to others. If you update the workbook in OneDrive, your readers will automatically see the latest in the embedded view.įirst, store your workbook in OneDrive. Your readers can sort, filter, and calculate data, directly in your post. With your Excel workbook stored on OneDrive, you can embed it into your blog. Sharing from SharePoint or OneDrive for Business? Go here. ![]()
0 Comments
Leave a Reply. |