My Slicers are not visible in excel office 365 on my sharepoint site.

Herman Theng 0 Reputation points
2023-04-19T02:22:47.5133333+00:00

My slicers are on the excel file however, when I access it on sharepoint it seems to disappear. How can I fix this?

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,641 questions

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 21,856 Reputation points Microsoft Vendor
    2023-04-19T10:26:04.2366667+00:00

    Hi,

    What kind of slicer did you use?

    Only local PivotTable slicer creation is available in Excel for the web. To create slicers for tables, data model PivotTables, or Power BI PivotTables, please use Excel for Windows or Excel for Mac.

    Hope the information is helpful.

    If the response is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.
    0 comments
  2. Dillon Silzer 54,471 Reputation points
    2023-04-19T04:37:56.75+00:00

    Hello Herman,

    This is most likely due to when you open the file on SharePoint it is opening it with Excel Online.

    Excel online is a much more limited version of Excel 365 (desktop app). You will need to right click the file in SharePoint and Open with Desktop app. (Open in app).

    If this is helpful please accept answer.

    0 comments
  3. Tanay Prasad 2,105 Reputation points
    2023-04-28T11:47:45.3666667+00:00

    Hi,

    When an Excel file with slicers is uploaded to SharePoint, it is possible that the slicers may not appear due to certain compatibility issues. Here are a few steps you can try to fix this issue:

    1. Ensure that the Excel file is saved in the appropriate format for SharePoint.
    2. Check if the slicers are added to the worksheet (not on a separate sheet) and are not hidden. If they are hidden, try unhiding them.
    3. Try refreshing the data connections in the Excel file. Go to the "Data" tab and click "Refresh All" in the "Connections" section. This will update any external data sources used in the Excel file.
    4. Try removing and then re-adding your slicers to the worksheet.

    If none of these steps work, check if there are any compatibility issues between the version of SharePoint you are using and the version of Excel you created the file with.

    Best Regards.

    0 comments
  4. Russell, Lori J 0 Reputation points
    2024-03-28T16:23:22.61+00:00

    I had this issue, except only a couple of the slicers were missing. My solution was to open the file in desktop and manually click the save icon and then the slicers popped back into the SharePoint version.

    0 comments