ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    "Export To Excel" Option in Onedrive for Business

    IT Discussion
    3
    10
    2.2k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • BRRABillB
      BRRABill
      last edited by

      I recently noticed an "Export to Excel" option started popping up when using ODfB. We use ODfB a lot to share files without O365 accounts to external people.

      Wondering what it did, I clicked it, and it downloaded an Excel IQY file, which, when opened, displayed the contents of my entire ODfB folder. Not just the share. Everything.

      Upon testing, it appears that only I can open that file, but I still think it
      a) potentially gives out information that it doesn't need to and
      b) is confusing to users just accessing a website to download a shared file

      I asked if there was a way to remove it, and apparently there is not. They suggested maybe "Sharepoint Designer" could remove it, and suggested requesting removal as a future feature.

      This is what is inside the IQY file.

      WEB
      1
      https://brra-my.sharepoint.com/personal/testuser_brra_com/_vti_bin/owssvr.dll?XMLDATA=1&List={D2B1E8AC-E8C2-49A1-8504-B6CA30CE747B}&View=AD6647D0-8735-4E1B-8868-A1493BEB44A9&RowLimit=0&RootFolder=%2fpersonal%2ftestuser%5fbrra%5fcom%2fDocuments
      
      Selection={D2B1E8AC-E8C2-49A1-8504-B6CA30CE747B}-AD6647D0-8735-4E1B-8868-A1493BEB44A9
      EditWebPage=
      Formatting=None
      PreFormattedTextToColumns=True
      ConsecutiveDelimitersAsOne=True
      SingleBlockTextImport=False
      DisableDateRecognition=False
      DisableRedirections=False
      SharePointApplication=https://brra-my.sharepoint.com/personal/testuser_brra_com/_vti_bin
      SharePointListView=AD6647D0-8735-4E1B-8868-A1493BEB44A9
      SharePointListName={D2B1E8AC-E8C2-49A1-8504-B6CA30CE747B}
      RootFolder=/personal/testuser%5fbrra%5fcom/Documents
      

      0_1522778585178_0a1e580b-8e94-4d82-ab4c-aacecd2b5529-image.png

      1 Reply Last reply Reply Quote 0
      • scottalanmillerS
        scottalanmiller
        last edited by

        There is an option in the account settings called "stop using ODfB" that fixes this 😉

        BRRABillB 1 Reply Last reply Reply Quote 0
        • BRRABillB
          BRRABill @scottalanmiller
          last edited by

          @scottalanmiller said in "Export To Excel" Option in Onedrive for Business:

          There is an option in the account settings called "stop using ODfB" that fixes this 😉

          Can you send a screenshot of that?

          scottalanmillerS 1 Reply Last reply Reply Quote 0
          • scottalanmillerS
            scottalanmiller @BRRABill
            last edited by

            @brrabill said in "Export To Excel" Option in Onedrive for Business:

            @scottalanmiller said in "Export To Excel" Option in Onedrive for Business:

            There is an option in the account settings called "stop using ODfB" that fixes this 😉

            Can you send a screenshot of that?

            https://www.linux.com/sites/lcom/files/styles/rendered_file/public/nextcloud_a.png?itok=PIW5p2UH

            1 Reply Last reply Reply Quote 1
            • JaredBuschJ
              JaredBusch
              last edited by

              @brrabill said in "Export To Excel" Option in Onedrive for Business:

              https://brra-my.sharepoint.com/personal/testuser_brra_com/_vti_bin/owssvr.dll?XMLDATA=1&List={D2B1E8AC-E8C2-49A1-8504-B6CA30CE747B}&View=AD6647D0-8735-4E1B-8868-A1493BEB44A9&RowLimit=0&RootFolder=%2Fpersonal%2Ftestuser_brra_com%2FDocuments

              I popped that link in the file into my browser and got this.
              0_1522782970276_57ea60e3-9317-4804-97b0-c742063a5f3b-image.png

              I popped porn mode and tried it with this result.

              0_1522783022894_a1d05747-987c-4392-914d-9c57e394155a-image.png

              1 Reply Last reply Reply Quote 0
              • JaredBuschJ
                JaredBusch
                last edited by

                So you just want to disable the option so people do not get confused?

                That will never happen. Users will always get confused.

                1 Reply Last reply Reply Quote 1
                • BRRABillB
                  BRRABill
                  last edited by

                  I guess it just seemed odd to have it there, to serve up a listing of files.

                  I guess if no one can me can get to it, it's not a concern. But then, why put it there? Or only put it there for the users with access to it.

                  scottalanmillerS 1 Reply Last reply Reply Quote 0
                  • scottalanmillerS
                    scottalanmiller @BRRABill
                    last edited by

                    @brrabill said in "Export To Excel" Option in Onedrive for Business:

                    I guess it just seemed odd to have it there, to serve up a listing of files.

                    I guess if no one can me can get to it, it's not a concern. But then, why put it there? Or only put it there for the users with access to it.

                    Well then, with that logic, why click on it?

                    BRRABillB 1 Reply Last reply Reply Quote 0
                    • BRRABillB
                      BRRABill @scottalanmiller
                      last edited by

                      @scottalanmiller said in "Export To Excel" Option in Onedrive for Business:

                      @brrabill said in "Export To Excel" Option in Onedrive for Business:

                      I guess it just seemed odd to have it there, to serve up a listing of files.

                      I guess if no one can me can get to it, it's not a concern. But then, why put it there? Or only put it there for the users with access to it.

                      Well then, with that logic, why click on it?

                      I like to see what can break.

                      scottalanmillerS 1 Reply Last reply Reply Quote 0
                      • scottalanmillerS
                        scottalanmiller @BRRABill
                        last edited by

                        @brrabill said in "Export To Excel" Option in Onedrive for Business:

                        @scottalanmiller said in "Export To Excel" Option in Onedrive for Business:

                        @brrabill said in "Export To Excel" Option in Onedrive for Business:

                        I guess it just seemed odd to have it there, to serve up a listing of files.

                        I guess if no one can me can get to it, it's not a concern. But then, why put it there? Or only put it there for the users with access to it.

                        Well then, with that logic, why click on it?

                        I like to see what can break.

                        I mean for the users.

                        1 Reply Last reply Reply Quote 0
                        • 1 / 1
                        • First post
                          Last post