Updating sheet list in excel
(so you could fill the value of the cell with AA, QF, etc). Excel has a very powerful feature providing for a dropdown select list in a cell, reflecting data from a named region.
It'a a very easy configuration, once you have done it before.
They are also useful for limiting the choices an Excel spreadsheet user can make when editing a cell.
This value could be a named range or a range of cells.
A named range is simply a name, such as “=Sales”, that someone assigned to a range of cells.
There are two ways to program a spreadsheet to update automatically: every time the workbook is opened and at regular intervals that you determine. Make sure you are on the "Usage" tab of the "Connection Properties" dialog box.
Select the "Refresh Every" check box and enter the number of minutes you want Excel to wait between automatic updates.
This can be done from Access not a problem however I need it to be Excel only.