locked
Editing Excel in browser mode... RRS feed

  • Question

  • Hi

    Is it possible to have an Excel file (added via the web part) in either PDP or in the Project Site where I can edit in Browser mode and not have to open the Excel file?

    Many thanks

    James



    • Edited by JamesP435 Sunday, July 23, 2017 12:38 PM
    Sunday, July 23, 2017 12:38 PM

All replies

  • Hi, here are the options that you have within a webpart:

    Adding additional content and switching the tabs is possible without opening the file in the client.


    Best regards,

    Julian, PMP, MCP, MCSA, MCSE

    Blog: https://project-brain.com

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.


    Monday, July 31, 2017 6:57 AM
  • Hi Julian 

    Thanks for this.  However there doesn't seem to be an option to edit in Browser mode

    Cheers

    James 



    • Edited by JamesP435 Sunday, August 6, 2017 11:04 AM
    Sunday, August 6, 2017 11:04 AM
  • Hi James, no there's no option for that.

    Best regards,

    Julian, PMP, MCP, MCSA, MCSE

    Blog: https://project-brain.com

    Note: Posts are provided “AS IS” without warranty of any kind, either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.

    Sunday, August 6, 2017 6:45 PM
  • Editing within the browser is only available with OWA.

    Do you have OWA installed and configured for SharePoint?    Which version are you running?  OWA is configured differently for each version of SharePoint. 


    Michael Wharton, MVP, MBA, PMP, MCT, MCTS, MCSD, MCSE+I, MCDBA
    Website http://www.WhartonComputer.com
    Blog http://MyProjectExpert.com contains my field notes and SQL queries

    • Marked as answer by JamesP435 Friday, September 15, 2017 6:24 AM
    • Unmarked as answer by JamesP435 Friday, September 15, 2017 6:24 AM
    Sunday, August 6, 2017 11:50 PM
  • Hi Michael

    Sorry for the delay in getting back to you.  

    Only using POL (no SP has been configured).  I'm assuming it can't be done then?

    Many thanks 

    James




    • Edited by JamesP435 Friday, September 15, 2017 6:27 AM
    Friday, September 15, 2017 6:26 AM
  • Hi James,

    As a workaround, you may create a List on Project site and use the data sheet view which is kind of excel rows but not exactly the same. You can always export the data in excel when it's needed. The below is example from Task list..


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |Director- PPM Consulting and Managed Services| Blog: http://ppm365.blogspot.com/ LI: http://www.linkedin.com/in/amitkhare82

    Friday, September 15, 2017 8:44 PM