Ofline
11664 days on xHamster
105M profile views
45135K subscribers
14600 comments left

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.

Please or register to post comments
If spammers comment on your content, only you can see and manage such comments Delete all

Updating sheet list in excel introduction

Updating sheet list in excel

Recent posts

26-Nov-2018 04:25
26-Nov-2018 09:37
26-Nov-2018 16:11
26-Nov-2018 22:32