Forum Discussion
Solved
Refresh All Order
I have several PowerQuery connections on workbook and some Pivot Tables based on results When I do Data/Refresh All then 1st is refreshed pivot tables and 2nd PowerQueries so I need manu...
I didn't touch this issue for a long while, perhaps something from here https://techcommunity.microsoft.com/t5/excel/pivot-table-will-not-update-properly/m-p/100885 could help.
I didn't touch this issue for a long while, perhaps something from here https://techcommunity.microsoft.com/t5/excel/pivot-table-will-not-update-properly/m-p/100885 could help.
One more tech thing I not jet find any solution
Function =CELL("filename";a1) must give me path to the folder I keep my things
Unfortunately this gives me something like https://d.docs.live.net/cd1fc5b8xx99xxx2/... becouse I have to store my file (and reference file with data) in Onedrive to be synced with all PS-s I use
The other function =INFO("DIRECTORY") works weird
When I start Excel with empty workbook (or some other workbook) and open my workbook then this function works fine and gives my reference to right folder (My Documents in Onedrive)
BUt when I open Excel with my Workbook (1st document) then this same function points to C:\WINDOWS\system32\ and my reference folder isn't correctly found
I have no idea how CORRECTLY point to Onedrive folder from PowerQuery (there is no such function to access Environment or ...) and I need to use calculation from Excel
This is actually case prevent me transfer some PowerQueries to PowerBI - thee is no such workaround
Function =CELL("filename";a1) must give me path to the folder I keep my things
Unfortunately this gives me something like https://d.docs.live.net/cd1fc5b8xx99xxx2/... becouse I have to store my file (and reference file with data) in Onedrive to be synced with all PS-s I use
The other function =INFO("DIRECTORY") works weird
When I start Excel with empty workbook (or some other workbook) and open my workbook then this function works fine and gives my reference to right folder (My Documents in Onedrive)
BUt when I open Excel with my Workbook (1st document) then this same function points to C:\WINDOWS\system32\ and my reference folder isn't correctly found
I have no idea how CORRECTLY point to Onedrive folder from PowerQuery (there is no such function to access Environment or ...) and I need to use calculation from Excel
This is actually case prevent me transfer some PowerQueries to PowerBI - thee is no such workaround
Do we speak about OneDrive Personal? I have no experience with it, I only know that Power Query doesn't like it. Loading a File from OneDrive Personal into Power BI Desktop - Excelerator BI