Results 1 to 2 of 2

Thread: Check if sheet exists before executing the Power Query

  1. #1
    Neophyte Galven's Avatar
    Join Date
    Feb 2020
    Posts
    2
    Articles
    0
    Excel Version
    2016

    Check if sheet exists before executing the Power Query



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

    Hi,
    I have the sheet name entered as parameter, depending on a cell in Excel. I'd like to prevent Power Query from getting an error if the entered sheet doesn't exist. Any possibility to insert in the query a "if sheet X exists then keep going else stop" ?
    Thanks.

  2. #2
    Administrator AliGW's Avatar
    Join Date
    Nov 2015
    Location
    Ipswich, Suffolk, England
    Posts
    1,376
    Articles
    0
    Excel Version
    Office 365 Subscription
    Have you looked that the try ... otherwise ... syntax?
    Ali
    Enthusiastic self-taught user of MS Excel!

Posting Permissions

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