Hi,
I have set up an Excel spreadsheet which is linked to, and updated from, an MS Access database. Within the Excel spreadsheet I have many cells that are populated from other cells in the document by way of examples below:
=(B5) or
=IF(ISBLANK('Mix Design'!D40)," ",('Mix Design'!D40))...