Forum Discussion

bethmsu96's avatar
bethmsu96
Copper Contributor
Oct 26, 2020

Trouble with sharing Excel Workbook

I want to control who has access to several shared excel workbooks, so I stopped using the copy link and started using where you have to type that person's email address.  As I understand that when y...
excel
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Oct 26, 2020
* Knowing the Excel version and operating system would also be an advantage.


Thank you for your understanding and patience


Nikolino
I know I don't know anything (Socrates)
bethmsu96's avatar
bethmsu96
Copper Contributor
Oct 26, 2020

NikolinoDE It is the excel from the Microsoft 365 package

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Oct 27, 2020

    bethmsu96 

    Unfortunately, I am not so familiar with Office 365 that I could give advice. But I will send you some links with information where they might help you. Until one of the specialists here takes on your topic.
     

    Use shared workbooks with different versions of Excel

    https://docs.microsoft.com/en-us/office/troubleshoot/excel/use-shared-workbook

     

    About the shared workbook feature

    https://support.microsoft.com/en-us/office/about-the-shared-workbook-feature-49b833c0-873b-48d8-8bf2-c1c59a628534?ui=en-us&rs=en-us&ad=us

     

    Note. When Microsoft Excel refuses to share a particular workbook, it is most likely due to one of the following reasons:
    That is for the versions Excel 2010, 2013 and 2016, I cannot confirm whether it is also at 365 ... but you don't know before you have tried it.
    Workbooks that contain tables or XML maps cannot be shared. So make sure to convert your tables to ranges and remove the XML cards before sharing your Excel file.
    In order to be able to share a workbook, some data protection settings must be deactivated. Go to File> Excel Options> Trust Center, click the Trust Center Settings… button, and under the Privacy Options category, clear the Remove personal information from file properties when saving check box.

     

    Excel has many solution paths how to solve a problem, so it is as simple complex :).

     

    I hope I was able to help you at least a little.

    I would appreciate your feedback.

    I wish you lots of fun with Excel ... the best invention from Microsoft since there was chocolate :).

    Nikolino
    I know that I don't know (Socrates)

Resources