![]() ![]() For more information, see Comparing Excel Services in SharePoint to Excel Web App.ĭepending on how your environment is configured, some kinds of data connections are supported for workbooks displayed in a browser window, which enables you to refresh data. If you are using Excel Services or Excel Web App on premises (not in the cloud), the ability to display certain content in a browser window depends on whether Excel Services or Excel Web App is used to display a workbook. Exceptions includeĬharts that are part of a group of chartsĬharts that use certain kinds of data sources that are not supported for workbooks viewed in a browser window In general, charts, tables, PivotChart reports, and PivotTable reports are displayed in a browser window similar to how they are displayed in Excel. ![]() When you view or print a workbook in a browser window, some features might work differently, as summarized in the following table.Ĭalculations and calculation settings, including automatic, manual, and iterative calculation settings for ranges or worksheets work in a browser window similar to how they do in Excel.Ĭells, including cell values, merged cells, and cell content overview, are displayed in a browser window similar to how they are displayed in Excel.Ĭharts and tables, including PivotChart reports and PivotTable reports Features that are supported for viewing in Excel for the web Read more about file size limits for workbooks in SharePoint. Note: There are limits to the size of files you can view in SharePoint and the Power BI service. ![]() Workbooks in other formats, are generally not supported in Excel for the web.įor more information about Excel file formats, see Save a workbook in another file format. You can always download the original by going to File > Info > Previous versions.Ī workbook in this format can be opened but macros do not run in a browser window. Note: When you open this file format, Excel for the web will convert it to a newer. This article explains these differences.įile formats that are supported in Excel for the web For example, not all file formats are supported, and some features may work differently than the desktop app. However, there are some differences to be aware of. Excel for the web looks a lot like the Excel desktop app.
0 Comments
Leave a Reply. |