Hello, I am using the Link to External data function on most of my sheets that need to link to an inventory that is stored in a Master file.
So I have set up a Data Range in the Master file and am linking each other document to this external data. For a while this has worked quite well, but lately some docs display the following error message “unable to insert rows” and there are a couple of cells that in fact show the following: The link could not be updated.
How do I rectify this? I have tried resetting the master file data range and calling it with a different name. I have also made sure there are no frozen rows/columns in either sheets, have removed any data filtering, i neither sheets and have closed any possible “Find” windows.
I really cannot think of what else to do. Any help greatly appreciated as I am running all my indie business relying on this.