Export from Access to Excel Problem
Posted by Anthony Cook on February 13, 2002 3:54 AM
I am exporting queries from Access to Excel using an Access Macro action "TransferSpreadsheet". The data is transferring OK but the formula/lookup tables etc. in Excel are not recognising the new data exported from Access. How do you re-calculate the Excel workbook so that formula/lookup tables etc. recognise the new data exported from Access? (Auto/Manual Recalc doesn't help). Any suggestions would be welcomed.