Forum Discussion

Mahyar's avatar
Mahyar
Frequent Visitor
7 years ago
Solved

Power Query Opens Source Workbook on Refresh

Hi,    I have been experiencing an issue that when I refresh the query it opens the source workbook that it is refrencing. When I close the workbook it opens it again and again and again. It contin...
Need Help
  • Mahyar's avatar
    Mahyar
    7 years ago
    I believe it was short lived bug.
rpayne86's avatar
rpayne86
Frequent Visitor
4 years ago

I've done some more thorough testing, and have narrowed it down to XLSB files. If the source for the Powerquery is an XLSB, and if another user is in that file, it decides to spring open a copy of that file (as read only).

If another user doesn't have the file open, it typically refreshes ok.

 

If you change the file to an XLSM (Or probably XLSX), the issue does not occur whether another user has the file open or not.

As it happens I believe PQ pulls in the latest SAVED version of the file, not the Live copy, and so I'm confused why read/write even makes a blind bit of difference.

 

We bounced round ideas that perhaps because the XSLB does not use the openXML standard that this may be why it causes issues.

jyerram's avatar
jyerram
New Member
3 years ago

I tried one whole day on the issue and tried several things suggested on the internet. This is the only solution that really worked, I am amazed again at how simple, silly things matter again...