ODBC link to Excel in current year before the ledgers are closed for the prior year

Hi,

I have the ODBC link set up to extract info from Sage for our monthly accounts, by month and nominal codes. We don't close our ledgers until our Stat accounts are completed so the ledger is still showing prior year. Is there a way I can change the year to pick up 2022 even if the ledger is still on 2020 (I know this should be closed but there are reasons it hasn't been done yet) ?

Thanks,