Forum Discussion
Refresh All Order
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.
NikolinoDE - unfortunately no help
both options are well known and I know how to use them. My question is
"how to control the ORDER excel makes refresh (actually both during opening or during refresh all)
Actual behavior - all Pivot Tables refreshed first
All Queries refreshed after that
Logical order for refresh all might be dependency order like for formulas
PS! I'm 25+ Year Excel user (quite prof) but this particular option is hidden for me
PPS! and please don't offer create macros to refresh is predefined order - I know how to use macros but I hate macros.
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 workaroundDo 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
- Thank You - looks like there is the point
Background refreshing breaks dependency chain