+ Reply to Thread
Results 1 to 6 of 6

Shared Workbook Limitations

  1. #1
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Shared Workbook Limitations

    I couldn't easily find a thread covering this in summary level, so thought I'd post this as a quick reference:

    In a shared workbook, you cannot But you may be able to do the following
    Create an Excel table None
    Insert or delete blocks of cells You can insert entire rows and columns.
    Delete worksheets None
    Merge cells or split merged cells None
    Add or change conditional formats Existing conditional formats continue to appear as cell values change, but you can't change these formats or redefine the conditions.
    Add or change data validation Cells continue to be validated when you type new values, but you can't change existing data validation settings.
    Create or change charts or PivotChart reports You can view existing charts and reports.
    Insert or change pictures or other objects You can view existing pictures and objects.
    Insert or change hyperlinks Existing hyperlinks continue to work.
    Use drawing tools You can view existing drawings and graphics.
    Assign, change, or remove passwords Existing passwords remain in effect.
    Protect or unprotect worksheets or the workbook Existing protection remains in effect.
    Create, change, or view scenarios None
    Group or outline data You can continue to use existing outlines.
    Insert automatic subtotals You can view existing subtotals.
    Create data tables (data table: A range of cells that shows the results of substituting different values in one or more formulas. There are two types of data tables: one-input tables and two-input tables.) You can view existing data tables.
    Create or change PivotTable reports You can view existing reports.
    Write, record, change, view, or assign macros You can run existing macros that don't access unavailable features. You can record shared workbook operations into a macro stored in another nonshared workbook.
    Add or change Microsoft Excel 4 dialog sheets None
    Change or delete array formulas (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) Existing array formulas continue to calculate correctly.
    Use a data form to add new data You can use a data form to find a record.
    Work with XML data, including: None
    - Import, refresh, and export XML data
    - Add, rename, or delete XML maps
    - Map cells to XML elements
    - Use the XML Source task pane, XML toolbar, or XML commands on the Data menu



    The above information from http://office.microsoft.com/en-us/ex...010096833.aspx applies to Excel 2007.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  2. #2
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: Shared Workbook Limitations

    Just came across this while I was researching something for a client.

    Do all of these still apply in Excel 2016?

    Although it says you cannot create a table, I assume that you can still update tables?

    Any updates would be great.

    Many thanks
    Shirley
    Excel is a constant learning process and it's great to help each other. If any of us have helped you today, a click on the "reputation" star on the left is appreciated.

  3. #3
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Shared Workbook Limitations

    As it says on the link to the Microsoft article:

    Quote Originally Posted by Microsoft
    Applies To: Excel 2016 Excel 2013 Excel 2010 Excel 2007

  4. #4
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Shared Workbook Limitations

    Quote Originally Posted by shirleyxls View Post
    Although it says you cannot create a table, I assume that you can still update tables?
    Hi,

    You can't share a workbook if it has a Table in it.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  5. #5
    Valued Forum Contributor
    Join Date
    01-08-2011
    Location
    Portsmouth, England
    MS-Off Ver
    Excel 2007 to 2016
    Posts
    456

    Re: Shared Workbook Limitations

    Thanks guys

    Pain that you can't share workbooks with tables though. Design rethink!

  6. #6
    Forum Contributor sorensjp's Avatar
    Join Date
    12-23-2015
    Location
    Yokosuka, JP
    MS-Off Ver
    2007 and 2016
    Posts
    196

    Re: Shared Workbook Limitations

    Hello All,

    Here is a different way to "Share" a workbook https://youtu.be/WI-uhkrnk2I. I've been following Excel for Freelancers on YouTube by Randy Austin and have been learning a lot about Excel.

    I've been learning so much from this Forum as well and must say "Thank you" to everyone.

    Forgot to say the attachment is what I downloaded from his site.

    Jim
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. limitations in a shared workbook.
    By cherryt in forum Excel General
    Replies: 5
    Last Post: 07-21-2013, 05:31 PM
  2. Replies: 0
    Last Post: 11-19-2012, 09:28 AM
  3. Replies: 0
    Last Post: 11-15-2012, 11:40 AM
  4. Shared Workbook/Workbook to be used by many people
    By BigBas in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-16-2012, 08:31 AM
  5. Shared Workbook (Workbook Open Code)
    By Chard in forum Excel General
    Replies: 5
    Last Post: 05-30-2007, 09:04 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1