Is there a way to get a list of worksheets or files that are being referenced on a worksheet. I would like to be able to easily distinguish which files are being referenced in a spreadsheet so I know where updates may need to be made. Any thoughts? Can VBA be used?
Bookmarks