Forum Discussion
Loading Excel With =Value into PowerBI
Hello, I have a script that is saving down a grouping of excels. Unfortunately, the cells have =Value (meaning one cell might have "=324" and another may have "=4237") and because of this when I ...
So it appears it is more related to the fact that the files are in Protected View when saved down from the source. If I click enable edit and then save again it pulls through al the data correctly in power query. Any thoughts on how to surpass that in power query?
I downloaded an Excel from the internet with several formulas and connected to it without clicking Enable Editing. However, I cannot replicate your issue. That aside and from experience, Enable Editing disappears if a file is saved in OneDrive..