Forum Discussion

Kds1113's avatar
Kds1113
Helper I
3 years ago
Solved

PowerQuery deactivating

I'm having a bizarre issue with my PQ and I haven't been able to find any solutions to this issue posted anywhere.  I was working on an .xlsm file on Friday and everything was working fine.  I come i...
Need Help
  • Kds1113's avatar
    Kds1113
    3 years ago

    Hi Gao - I was using tables within the workbook as the source and am using Excel as part of Microsoft 365 Apps for enterprise.  But - i figured out what the issue was.... some of the workbooks had the workbook structure protected and some didn't.  Once I entered the passwod, which luckily was given to me prior to the creator's departure, the PQ options reappeard.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Kds1113 ,


It's hard to say. Could you reveal more details about this issue? What is the version of excel you are using? What is the data source?

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly -- How to provide sample data

  • Kds1113's avatar
    Kds1113
    Helper I
    3 years ago

    Hi Gao - I was using tables within the workbook as the source and am using Excel as part of Microsoft 365 Apps for enterprise.  But - i figured out what the issue was.... some of the workbooks had the workbook structure protected and some didn't.  Once I entered the passwod, which luckily was given to me prior to the creator's departure, the PQ options reappeard.