Computer Training & Application Solutions made Simple
Contact us for a free consultation
  • Click to send us an email. We'd love to hear from you!   Ottawa       613-656-4229
  • Click to send us an email. We'd love to hear from you!   Montreal    514-342-9494

Excel Shared Files

By Deborah J. Sparks

Although Excel does allow files to be shared so that multiple users can work in the file at the same time, very often it creates problems, such as those listed below.

In Shared Files You Cannot

  • Add Excel tables
  • Add or change conditional formatting
  • Merge or split cells
  • Create or change pivot tables
  • ... and more. For a complete list of features that are not supported when sharing workbooks, consult Microsoft's website, by clicking here.

 

Conflicting Changes

  • These occur when, for example, more than one user makes changes in the same cell

 

So, what options do you have? If workbooks are shared by a limited amount of users who won't be editing at the same time and you don't use the features that are not supported, shared workbooks might be just fine for you.

Otherwise, it may be time to consider using MS Access, which is designed for multiple users.

 

Still not sure? Click here to read an article that may help you decide.

 



More Newsletter Articles

© 2013 DJH Training & Application Solutions Inc.

WOULD YOU LIKE TO USE THIS ARTICLE IN YOUR NEWSLETTER, EZINE OR WEB SITE? You can, as long as you include this complete blurb with it: An entrepreneur at heart, Deborah J. Sparks established DJH Training & Application Solutions Inc. over 20 years ago, realizing her dream of creating a company known for providing high quality computer software training, application development and support and exercising her passion for teaching. To learn more and to register for DJH's free newsletter, Innovations, please visit www.djhsolutions.ca.