Open two workbooks in Excel for the web. They should be stored in either OneDrive or SharePoint. In the source workbook, copy the range. In the destination workbook, “paste links” via the right click menu or via paste special on the home tab. The gif below provides a brie...
Hello everyone, I am an Excel 365 web user. I want to link two files, both files stored in my OneDrive. I would like to do this in Excel 365 Web. I tried this procedure (copy - paste link): https://www.neowin.net/news/microsoft-brings-support-for-external-workbook-links-to-e...
Excel formula external link to workbook on OneDrive returns REF status The formula is referencing the external file via this path: 'https://d.docs.live.net/1b1ecec231c6xxx/CapApp/TrailLife/[TL Sales by Item 10-01-2022 to 09-30-2023.xlsx]PT by Item by Month'!$A:$A. In...
I am currently trying to set-up and link a set of tables from excel to the word (printable) version. Up till now the process has been manual (where we copy the tables from excel and paste on word). We have started linking these tables from the excel to the word version, so that w...