Results 1 to 4 of 4

Thread: Use of queries by multiple users in synchronized Sharepoint local folders

  1. #1
    Neophyte Manelmt's Avatar
    Join Date
    Oct 2019
    Posts
    3
    Articles
    0
    Excel Version
    365

    Use of queries by multiple users in synchronized Sharepoint local folders



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello everyone!!
    First of all apologize in case something is not understandable, I write from Catalonia, my level of English is low and I am using Google Translator.

    I have an Excel file with queries to several folders on my PC. These folders are actually synchronized OneDrive or SharePoint folders that we share among several users. The original file is also saved inside the shared folders, so that any user with access can use it.
    The problem is that when a user makes a query of data in Excel, the route where he is going to look for the data (in local) goes through C: \ Users \ "User Name" \ Sharepointů.
    As each username is different, the file only works if it is used by the user who created it, so that we cannot share our queries ... My question is:
    Can I link the data source of a query (Excel) to the value of a cell? In this way, each user can enter their name in said cell and the route will be linked to that value, which corresponds to the connected user.
    Is there another solution for this problem?
    I tried using Miguel's blog solution "https://www.poweredsolutions.co/es/2019/04/04/conectar-a-archivos-en-sharepoint-y-onedrive-con-power-bi-power- query / "but it doesn't work for me, I guess for a permissions issue (corporate computer" capped ") ...

    I published this same query on the Powered Solutions Blog "https://foro.poweredsolutions.co/topic/264-archivo-excel-compartido-por-varios-usuarios/" and Miguel indicated your website as a help method.

    Thank you very much in advance!!
    Manel


  2. #2
    Neophyte Manelmt's Avatar
    Join Date
    Oct 2019
    Posts
    3
    Articles
    0
    Excel Version
    365
    Nobody can Help me?
    Thanks.

  3. #3
    Acolyte NormS's Avatar
    Join Date
    Jul 2017
    Posts
    26
    Articles
    0
    Excel Version
    Excel 2016 ProPlus

  4. #4
    Neophyte Manelmt's Avatar
    Join Date
    Oct 2019
    Posts
    3
    Articles
    0
    Excel Version
    365
    Wow !!
    After not a few problems in translation (my English is very basic) IT WORKS !!!
    How big !!
    Many Thanks!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •