Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Opening Password Protected excel workbook through power query

  1. #1
    New Member
    Join Date
    May 2015
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Opening Password Protected excel workbook through power query


    Opening Password Protected excel workbook through power query
    Hi,

    How to open a password protected workbook through power query?

    Thanks in advance for a help.

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    1,625
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Opening Password Protected excel workbook through power query

    I think you'll need to remove password first then import into PQ
    I know you know but I don't know what you know



    Post your Excel version (PC / Mac?), also link to shared excel file with representative example of source data and expected result.
    impossible things we do on the spot. for miracles you need to wait for a while

  3. #3
    New Member
    Join Date
    May 2015
    Posts
    31
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Opening Password Protected excel workbook through power query

    Thanks, but can't we set password in Power Query. I do not want to open the excel and update the password every time we have new fie

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    1,625
    Post Thanks / Like
    Mentioned
    9 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Opening Password Protected excel workbook through power query

    so answer is: no, you can't
    I know you know but I don't know what you know



    Post your Excel version (PC / Mac?), also link to shared excel file with representative example of source data and expected result.
    impossible things we do on the spot. for miracles you need to wait for a while

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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