I have 2 queries appended.
Each query contains a different budget version. Every year new budget versions get created and overwrites current data.
What i'm trying to do is exclude a query from refreshing in the appended query because otherwise, the current data will be overwritten with new data next year and i want to keep all data.
Hope you guys understand what i mean :D
Example:
We currently have 2 budgetversions : C21 and CBE. CBE gets saved as CBE Year, CBE Y+1,..., CBE Y+9 C21 gets saved as V1 Year , V1 Y+1,... , V1 Y+9
C31 will be our new budgetversion and will be saved as V1 Year, V1 Y+1 , thus overwriting current C21 data.
As we do want an overview of all the budgetversions, i do want to exclude the C21 query from refreshing so we have a full overview of CBE / C21 and C31 data. If i don't freeze the C21 query, it will be loaded with C31 data.