Forum Discussion

tothrec2's avatar
tothrec2
Copper Contributor
Mar 14, 2022
Solved

Using templates in web version of Excel

When I attempt to open a downloaded Excel template in the web version of Excel, the page goes into an infinite loop of a few pages that flash by.

 

I cannot find any page that indicates whether or not templates are even supported in the web version of Excel.

 

The only instructions I can find all reference the App.

 

If this is supported in the web version, how it is done? 

If it is not supported, why is it not documented?

 

Steven

3 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    tothrec2 

    Excel for the web looks a lot like the Excel desktop app. However, there are some differences to be aware of. For example, not all file formats are supported, and some features may work differently than the desktop app. This link explains these differences.

    Differences between using a workbook in the browser and in Excel

     

    Additional Information:

    Free Excel for the web templates on Office.com

     

    Hope I was able to help you with this information.

     

    NikolinoDE

    I know I don't know anything (Socrates)

    • tothrec2's avatar
      tothrec2
      Copper Contributor

      NikolinoDE ,

         Thank you so much for the reply and for answering my question.

       

      I don't see xlts in the list of supported file types and that is the file type I downloaded for the template I wanted to use.

       

      Steven

      • NikolinoDE's avatar
        NikolinoDE
        Platinum Contributor

        tothrec2 

        To view or edit in Office for the web, use the following table to check which file formats are supported.

        Unable to View or Edit Office files by using Office Online or Office Web Apps

        Microsoft Excel

        File formatView in Excel for the web or Excel Web AppEdit in Excel for the web or Excel Web App

        Open XML (.xlsx)

        Yes

        Yes

        Binary (.xlsb)

        Yes

        Yes

        Binary (.xls)

        Yes on OneDrive

        Not on SharePoint

        Yes on OneDrive.

        Not on SharePoint.

        Macro (.xlsm)

        Yes

        Yes. However, you are prompted to create a copy of the file that has the macros removed when you save the changes that you have made.

        Other file formats (.xltx, .xltm, .xlam, .xlm, .xla, .xlt, .xml, .xll, .xlw,ods, .prn, .txt, .csv, .mdb, .mde, .accdb, .accde, .dbc, .igy, .dqy, .rqy, .oqy, .cub, .uxdc, .dbf, .slk, .dif, .xlk, .bak, .xlb)

        No

        No

         

        Hope this information was helpful to you.

         

        Please do not forget that what Excel for web cannot yet do, it will be able to do.

         

        I wish you continued success with Excel.

         

        NikolinoDE

        I know I don't know anything (Socrates)

Resources