Forum Discussion
Need an explanation on Compatibility Checker.
- HansVogelaar
Thank you again. I figured out how to find the links between both workbooks. They are all within the Logs. I'm going through them now and fixing the data validations. Thank you again. You are a lifesaver!
Thanks! When I open the template, I get a warning about links.
If I click Edit Links..., I see this:
If I click Break Link and confirm, the link is no longer listed.
I can then save and close the template, Next time, the warning is gone.
Thank you for your response.
This is strange because this is what I get:
In "Data" tab of ribbon-Connections section-->Edit Links
Popup:
Click: Break Link
Popup:
Click: Break Links:
Popup returns Edit Links window with Source still there:
Do you know what could be happening within my Excel software that would cause this to not break but within yours it does?
I don't know what causes that.
The links are sources of data validation drop downs on the MSR...Log sheets. For example, G17 and H17 on MSR2Log:
- HansVogelaar
Thank you again. I figured out how to find the links between both workbooks. They are all within the Logs. I'm going through them now and fixing the data validations. Thank you again. You are a lifesaver! - THANK YOU SO VERY MUCH!!!! I went into the Log and set the validation to the correct worksheet withing the workbook. How were you able to drill down to find it was within the validation? Is there something I could have done to have found this out? I'm wondering if there is something else similar to this since I still can't break the link within the book.
I couldn't find any links in formulas or named ranges, so data validation was the next potential culprit.
I ran some VBA code that I have to analyze the data validation rules in the workbook, and that is how I found some rules that refer to the other workbook.
I still have no idea why you cannot break the link while I can do that.