Here's a typical formula in the dependent worksheet:
(The slave is "CABINET DATABASE JAN 2012.xlsx)
=IF(F382>0,(VLOOKUP(F382,'C:\Documents and Settings\Geoffrey Dunn\My Documents\Cabinet Guy\Cabinet Pricing & Templates\CABINET DATABASE JAN
Here's some background. I wrote a large pricing database sheet on Excel 2007 for individual custom kitchen cabinets that has standard module sizes, details and pricing. I then have a dependent master template which pulls info from that when I enter a specific module cabinet code. When I have a new job I open the template and rename it for that client. Then I enter the specific cabinet codes to come up with a sales price and material and labor costs for that job.
This program worked fine for 4 years when I ran it on XP. By that I mean it automatically updated the cells as I entered them without asking me to edit the links.
>Now that I have switched to Win7 and open a template a dialogue box pops up that says "This workbook contains one or more links that cannot be updated" and offers "Continue" or "Edit Links" options.
>I click the edit button and a box pops up showing the correct workbook ("CABINET DATABASE JAN 2012" (this is the same box that comes up when you click the Edit Links tab).
>It labels this workbook as "unknown" and I have to hit the "Open Source" button and click on the correct file. Occasionally it actually recognizes it.
>If I happen to have the slave workbook open (which I need to do from time to time to edit it) then when I click the "Open Source" button and specify the sheet the dialogue box then specifies that workbook as OPEN and it will not update. In that case I have to close it to get the dependent sheet to update. (it didn't do this in XP).
SO, the botXXXXX XXXXXne issue is why does Excel need to be shown where this file is each and every time I open the dependent sheet and then also need me to intermittently hit the edit links tab again? It used to work automatically and seamlessly in XP (in fact I was barely aware of the edit links dialogue box and never had to use it).
Notes: 1) All the options in Excel are set for auto updates, 2) the "startup prompt" button at the bottom left of the edit links box always defaults to "Let users choose to display the alert or not" even though I have hit the radio button that says "Don't display the alert and update links 3) Excel is completely up-to-date and I have run diagnostics on it with no issues.