I have a program that contains a lookup formula that references data linked to an Access database.
I have "ActiveWorkbook.RefreshAll" at the beginning of the program but sometimes the workbook does not refresh. Any suggestions?
Also, is there VBA code I can use to cross reference instead of putting a lookup formula in every cell?