Is there a way to refresh bookmarks? I have a bunch of small workbooks and have a few master workbooks that consolidate these with bookmarks. I need a way to refresh the master workbooks. Are bookmarks the way to do this or will I need to recreate each sub-workbook in the master workbook?
Unless you're dynamically populating the list from a DB, I believe you'll have to manually edit your master workbooks to link to the new ones.