Forum Discussion

Michael1105's avatar
Michael1105
Brass Contributor
May 16, 2023
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...
excel
  • Michael1105's avatar
    Michael1105
    May 17, 2023
    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!
HansVogelaar's avatar
HansVogelaar
MVP
May 16, 2023

Michael1105 

You can upload the file to a cloud store such as Google Drive, OneDrive or Dropbox.

Then obtain a link to the uploaded file and paste that link into a reply.

  • Michael1105's avatar
    Michael1105
    Brass Contributor
    May 17, 2023

    HansVogelaar. Thank you for your reply. Here is the link to the shared file:
    https://1drv.ms/x/s!AhzfESS2_HcpimOtyyl-olgD4yxA?e=6dUAdd

    I downloaded the shared file through the link and now it's not showing the error message. However, the connection to the other workbook is still there.

    Here is the link for the New Branch Scorecard workbook is connected to: https://1drv.ms/x/s!AhzfESS2_HcpimT95q42nF12afv_?e=umklzv

     

    Thank you so very much for taking the time in looking into this for me.  I appreciate this very very much.  🙂

    Both workbooks should have the sheets unprotected.

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      May 17, 2023

      Michael1105 

      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.

      • Michael1105's avatar
        Michael1105
        Brass Contributor
        May 17, 2023

        HansVogelaar 

        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?

         

Resources