I have a client that has requested multiple workbooks that are managed by different vendors to be published to one workbook on Server. I'm almost certain there is no way to do this specific request, but in his mind this is the best way to manage the Server site.
I have several alternatives in mind, but before I tell my client that multiple people cannot publish to one workbook on Server I'd like some reassurance that I'm not wrong.
Publishing a workbook with the same name, in the same project will overwrite the workbook on server. There isn't a way to merge the two workbooks just on server or when publishing.
You could publish workbook 1 to server, then have vendor 2 open workbook 1 in Desktop from the server and merge workbook 2 sheets into workbook 1 and publish again.