Consulting

Results 1 to 3 of 3

Thread: Saving a spreadsheet in Teams

  1. #1

    Saving a spreadsheet in Teams

    hi All,

    I have created Stock Management spreadsheet that has a lot of macros and forms. This is used by number of people across my organization and is currently saved in Teams. However, i have noticed that despite Teams supposed to be design to allow multi user use the same doc/spreadsheet at the same time, we are struggling with saving the latest version if more than one person has got this spreadsheet opened.

    Do you think it is Teams issue or a spreadsheet's?

  2. #2
    Teams favors opening files in Excel on-line, which does not understand VBA. That may be part of your problem.
    Regards,

    Jan Karel Pieterse
    Excel MVP jkp-ads.com

  3. #3
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,704
    Location
    Just a thought:
    Distribute the Workbook with Forms and Macros, But save the Data to a Teams Spreadsheet
    I expect the student to do their homework and find all the errrors I leeve in.


    Please take the time to read the Forum FAQ

Posting Permissions

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