linked files

I have 2 workbooks Linked: Table 1 (Workbook 1) & Table 2 (Workbook 2). "Declined" items of Table 1 are to be listed in Table 2 (two different, but linked workbooks). So 'Declined' from Table 1 is the main judgement criteria. 1. Formula - Green cell in Table 2 - IF D2 of Table 1 is "Declined"...

I have an excel file that has numerous data connections to a database. How can easily edit the connection string to change the file name of the copied database? I need multiple sets of excel and access files to accommodate multiple users. Excel Template - Database Excel Template 2 - Database 2...

Hi everyone, New to this board. I have a PowerPoint template linked to an Excel template. I have about 20 linkeds charts, named ranges, etc. in my PowerPoint that links to the Excel template. Users open each template, rename for their particular project, and then save to a new network...

I have a workbook that scrapes month-to-date information from individual daily sheets. I obviously can't use INDIRECT with VLOOKUP to make each day's link different, so I have to hard code them all. Other than having to have each one reflect a separate day, these are very basic VLOOKUPs I'm...