Forum Discussion
Solved
Need an explanation on Compatibility Checker.
Hi, I've created a workbook that contains macros and somehow through the process of the book's creation I inadvertently created a link between this and another workbook. I started receiving the Exte...
- 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!
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:
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.