PDA

View Full Version : Linked Documents or appending Docs in Sharepoint Solution Needed



faodavid
2017-06-14, 03:30 PM
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

p45cal
2017-06-15, 09:18 PM
cross posted without links:
https://www.excelforum.com/excel-programming-vba-macros/1189180-linked-documents-or-appending-docs-in-sharepoint-solution-needed.html#post4676591
https://social.technet.microsoft.com/Forums/office/en-US/0d5a7e64-831d-4b86-8420-afad0aa5d9f4/linked-documents-or-appending-docs-in-sharepoint-solution-needed?forum=excel
https://social.msdn.microsoft.com/Forums/sharepoint/en-US/e275f3b9-1e45-4335-8bca-3861040e092c/linked-documents-or-appending-docs-in-sharepoint-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

faodavid
2017-06-16, 10:29 AM
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

p45cal
2017-06-16, 11:15 AM
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).

faodavid
2017-06-16, 11:24 AM
Apologies I didnt know I had to include links to posts on other forums, here they are

https://www.excelguru.ca/forums/show...olution-Needed (https://www.excelguru.ca/forums/showthread.php?7936-Linked-Documents-or-appending-Docs-in-Sharepoint-Solution-Needed)
https://social.technet.microsoft.com...ed?forum=excel (https://social.technet.microsoft.com/Forums/office/en-US/0d5a7e64-831d-4b86-8420-afad0aa5d9f4/linked-documents-or-appending-docs-in-sharepoint-solution-needed?forum=excel)
https://www.excelguru.ca/forums/show...2416#post32416 (https://www.excelguru.ca/forums/showthread.php?7936-Linked-Documents-or-appending-Docs-in-Sharepoint-Solution-Needed&p=32416#post32416)

Pecoflyer
2017-06-16, 01:22 PM
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

p45cal
2017-06-16, 02:17 PM
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.