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)) or
=AVERAGE(INDEX($T$9:$T$805,MATCH(E34,$Q$9:$Q$805,0)):INDEX($T$9:$T$805,MATCH(E35,$Q$9:$Q$805,0))).
Recently whenever I refresh the Excel spreadsheet from the database the embedded cell references no longer auto update, ie The only way to to see the imported information is to physically save the Excel spreadsheet at which point all the data will pop up onto the screen.
Any ideas what I should do
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)) or
=AVERAGE(INDEX($T$9:$T$805,MATCH(E34,$Q$9:$Q$805,0)):INDEX($T$9:$T$805,MATCH(E35,$Q$9:$Q$805,0))).
Recently whenever I refresh the Excel spreadsheet from the database the embedded cell references no longer auto update, ie The only way to to see the imported information is to physically save the Excel spreadsheet at which point all the data will pop up onto the screen.
Any ideas what I should do
