SOLVED

Using templates in web version of Excel

Copper Contributor

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
best response confirmed by tothrec2 (Copper Contributor)
Solution

@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)

@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

@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)

1 best response

Accepted Solutions
best response confirmed by tothrec2 (Copper Contributor)
Solution

@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)

View solution in original post