I have a file that I need to update monthly that is linked to another file. In order to update it, I need to link it to another file. A while ago I wrote simple macro to change part of the path (for example from xxx_5_2018 to xxx_6_2018). It worked fine, but suddenly stopped working.
I tried working around it by using ctrl+H to manually change the link, but I got the dreaded "we found a problem with one or more formula references in this worksheet" error message. There are no charts in the file and I only select cells with data to begin with. Any idea what it might be causing this error? Using "edit links" command creates the same result...
I tried working around it by using ctrl+H to manually change the link, but I got the dreaded "we found a problem with one or more formula references in this worksheet" error message. There are no charts in the file and I only select cells with data to begin with. Any idea what it might be causing this error? Using "edit links" command creates the same result...