Linking Workbooks I have a source workbook in SharePoint that links a table to a destination workbook, also in SharePoint. I am sharing the destination to an external user because I do not want the external user to have access to all of the other data in the source workbook. However, wh...
SharePoint: If your organization uses Microsoft SharePoint, you can store the Excel workbooks in SharePoint document libraries. SharePoint allows multiple users to access and collaborate on documents simultaneously. OneDrive: Microsoft OneDrive allows you to store Excel work...
At that point, you will run up against a different problem. Unless you took the greatest care, each user's Dropbox will be in a different Windows file path from every other user. Excel links unfortunately do not recognize this concept at all. You may find - like I did - that you hav...
SharePoint: If your organization uses Microsoft SharePoint, you can store the Excel workbooks in SharePoint document libraries. SharePoint allows multiple users to access and collaborate on documents simultaneously. OneDrive: Microsoft OneDrive allows you to store Excel workbooks in t...
SharePoint: If your organization uses Microsoft SharePoint, you can store the Excel workbooks in SharePoint document libraries. SharePoint allows multiple users to access and collaborate on documents simultaneously. OneDrive: Microsoft OneDrive allows you to store...
Linking Workbooks I have a source workbook in SharePoint that links a table to a destination workbook, also in SharePoint. I am sharing the destination to an external user because I do not want the external user to have access to all of the other data in the source workbook. However, ...
in between). In practice, Microsoft makes your life hell when you go down that route. One aspect of that hell is that you are fretting about a Workbook - containing your master list - being open. And you fret about this because, out of the box, Excel does not open linked Workbooks...
in between). In practice, Microsoft makes your life hell when you go down that route. One aspect of that hell is that you are fretting about a Workbook - containing your master list - being open. And you fret about this because, out of the box, Excel does not open linked Workbooks. ...
Workbooks (or any combination in between). In practice, Microsoft makes your life hell when you go down that route. One aspect of that hell is that you are fretting about a Workbook - containing your master list - being open. And you fret about this because, out of the box, Excel ...
Workbooks (or any combination in between). In practice, Microsoft makes your life hell when you go down that route. One aspect of that hell is that you are fretting about a Workbook - containing your master list - being open. And you fret about this because, out of the box, Excel ...