I've linked an access table to an excel workbook. If I define/name some formulas in the table in excel, will these work in the same way as a normal defined/named formula on a normal sheet in excel?
I ask because a quick google tells me names / ranges don't go the other way (excel to access) and would quite like to be able to link to the access tables in excel, refresh, and have my formulas do their thing.
HIIII GUYZ.
ME AGAIN!!!111!! lol.
I've linked an access table to an excel workbook. If I define/name some formulas in the table in excel, will these work in the same way as a normal defined/named formula on a normal sheet in excel?
I ask because a quick google tells me names / ranges don't go the other way (excel to access) and would quite like to be able to link to the access tables in excel, refresh, and have my formulas do their thing.