Common List in Multiple Excel Workbooks: Best Practice 1

[foundryqa]

Hi,

I'd like to find out what poeple consider to be the best practice for using a common list of items across several workbooks. Currently I have a list in each workbook and would like to make a central repository for all of them to access. I know that I can do lookups between workbooks, wondering if that is what most of you do or if you've got a better solution. Thanks,

Fred

 

[SkipVought]

Hi,

Consider one workbook as the database. Maintain that list.

Each other workbook can then QUERY the database to retrieve that table. There is a switch to cause the refresh to occur when the workbook opens, for instance. faq68-5829

Skip,
[sub]
[red][/red]
[/sub]

 

[foundryqa]

Thanks Skip.

Had a bit of problems with MSQuery not letting go of certain objects in the past when I've tried to break connections. That's made me a bit nervous about using it again, but I respect your input and will give it a shot.

Appreciate the quick response,

Fred

 

[SkipVought]

In my experience, this only happens when someone else has the workbook open (ie, if you query another workbook and, low and behold, that workbook stays open after the query is finished)

Skip,
[sub]
[red][/red]
[/sub]