![]() Please repeat after me: “Wow, I did not know I could do that. There is only one thing that remains here. As you can see, Export to Excel behaves quite interesting and somewhat unexpected when you export a document library with folders to Excel. That’s all I wanted to share with you in this blog post. In this case, log in to the SharePoint site/library via the Edge Browser and not Google Chrome and export the library from there and open the newly exported query.iqy file in Excel. In some cases, you might get the following message when you try to open the exported file “The server you are trying to access is using an authentication protocol not supported by this version of Office”. Analyze metadata use within the document library.Perform advanced analysis using Excel formulas, charts, tables.In this case, Export to Excel behaves the same way it does with the lists, it essentially exports the whole table (rows and columns) – the result is the table appearing in Excel instead of SharePoint. ![]() When you have a document library without folders, but with metadata, you probably do not need to worry about restructuring much however, you might need to perform some analysis, reporting using formulas and charts, which requires Excel. Make decisions about document library restructuring.Analyze the folder depth of the library.See, at a glance, document library contents.Hi All I have an Excel 2013 document that I've been using for over two months and have had no problems with editing or saving it. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |