Forum Discussion

Bertuccio's avatar
Bertuccio
New Member
4 years ago

Excel.CurrentWorkbook() crashes

Hi All,    Something really weird happened to me, and by extention, my colleagues. I set up recently (like a month ago) a new but very simple query that basicaly takes 2 existing tables, reshapes b...
Need Help
BA_Pete's avatar
BA_Pete
Super User
4 years ago

Hi Bertuccio ,

 

Where are your Excel files stored? Are they local (C: drive), in network folders, or SharePoint?

Are your Excel files shared with other users or o you have them open on your desktop while you're trying to load your PQ queries?

 

I believe any platform that doesn't essentially support 'checking out/in' of documents can cause PQ problems as it creates a 'file being used by another person' conflict.

 

Pete

  • Bertuccio's avatar
    Bertuccio
    New Member
    4 years ago

    Hi Pete, 

     

    Thanks for your answer. It's indeed on a sharepoint, and the Excel document itself grabs a lot of info from other sharepoints sources, even Sales Force. I did test to copy and paste this excel document on the desktop to try it out, and first thing I did was to remove the other querries, for no effect. 

     

    Update on this though, after 2 days not working at all, today it's ... working fine. I have no idea what happened as I did not upgrade my Office (it's Office 365, so it might be without me knowing) or change any option. The solution was apparently to leave it be for a day or two. 

     

    I'll leave this here for a bit if someone encountered this issue before, and maybe found a way.