Linked Documents or appending Docs in Sharepoint Solution Needed

Status
Not open for further replies.

faodavid

New member
Joined
Feb 2, 2015
Messages
22
Reaction score
0
Points
0
Hi
I have a central excel document used for contracting music shows stored in SharePoint that myself and 4 other people regular use, we are running into problems with several people wanting to use the document at the same time and getting a read only alert, thus delaying them
Co-authoring on SharePoint online is possible, but it’s too slow, has reduced functionality and loses formatting so isn’t suitable.
I am trying to think of ways to reduce the need for people to be in the contracting document at the same time, sometimes they will want to add a full new show (row) but other times they want to just check certain info
All four people work remotely not on the same server
I was wondering if it were possible to have separate linked documents on SharePoint that could be accessed locally? The master document would be used to add new shows, the other two documents would update from the master.
I’ve attached an example if you assume each of the tabs are a separate stand-alone document
Doc 1 (Full Contract) columns A – AM
Doc 2 (Deal) contains columns A-G and H – R from Doc 1
Doc 3 (Com) contains columns A-G and AJ – AM from Doc 1
The above documents are hypothetical – if a solution is possible I could do with understanding the process so that I can apply it to the correct documents
Alternatively could each person have their own full document which would update a master, someone previously has kindly created append documents using macros for me but I couldn’t get them to work on SharePoint – they said the problem was to do with SharePoint permissions but I checked this several times with Microsoft who confirmed all permission were in place and that they felt the document were corrupt. I have also attached these documents
I am open to any other suggestions of how to approach the problem if any has any suggestions

Thanks in advance

Dave
 

Attachments

  • FORUM QUESTION LINKING SEPARATE DOCUMENTS IN SHAREPOINT.xlsx
    33.9 KB · Views: 17
  • Append1.xlsm
    26.5 KB · Views: 16
  • Append2.xlsm
    26.2 KB · Views: 17
  • Master File.xlsm
    24.6 KB · Views: 18
cross posted without links:
https://www.excelforum.com/excel-pr...n-sharepoint-solution-needed.html#post4676591
https://social.technet.microsoft.co...ocs-in-sharepoint-solution-needed?forum=excel
https://social.msdn.microsoft.com/F...point-solution-needed?forum=sharepointgeneral

faodavid, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184
 
Last edited:
Apologies I wasnt aware of this - so If i post the same query across different forums I should include links to those posts, do I need to do that now?

Dave
 
Yes:
1. Here, if there are any links not already cited in this thread
2. Elsewhere, if those forums have similar rules (and it's very likely they do).
 
After 20+ posts here and 70+ posts on XLforum you still don't know adding ls is the least you can do to avoid members losing their time needlessly?
I doubt it
 
Prompted by Pecoflyer's last post, I did some digging and find that I've alerted you to the cross-posting links requirement at least twice before, November last year and as recently as the middle of last month.
So comments such as 'I wasnt aware of this' and 'I didnt know I had to include links to posts on other forums' don't wash.
I see there are still no links provided to here at ExcelForum.
It's humans who help you out at these forums, not machines.
Thread closed.
 
Status
Not open for further replies.
Back
Top