![]() ![]() And I need this for a report I am preparing at the moment.įor upcoming training course dates see: Pricing & availability The workbooks really do need to be on SharePoint for my colleagues to access and update, they are not functional if they only work on my local computer. How can I fix this? Or is it just not possible? When I open the workbook in Excel a dialogue box says there are external links and if I trust them I can update them, or work with the data I have. And where my data should be, there are #REF! errors. However when I reopened the workbook later in Excel Online, there was an error message in a ribbon at the top saying "Links disabled: Links to external workbooks are not supported and have been disabled". I successfully learnt how to use Vlookups using separate workbooks, but I want to know whether it is possible when they are on SharePoint, and how to do this?įor the table array, instead of typing in the external file name I instead dragged my mouse over the relevant table, and this automatically turned into a URL in the formula bar when I finished the formula and then selected it again to inspect it. I am trying to use a Vlookup using two separate Excel 2016 workbooks which are both on SharePoint. ![]() Vlookup using two workbooks on SharePoint
0 Comments
Leave a Reply. |