Linking xlsx and pptx files - issue when stored in OneDrive or SharePoint

When I link e.g. a graph from a xlsx file to a pptx file and both documents are stored localy there is no issue with an "automatic update" of the links. But as soon these files are stored on OneDrive or in SharePoint the activation of Link "automatic update" is not possible. Why? Can you provide a solution please.