Avoiding Shared Workbooks in Excel.Occasionally a client asks me to create a shared workbook in Excel, so two or more employees can work in it at the same time.It sounds good in theory, but I always try to come up with a different solution.Maybe youve had success with shared workbooks, and Id love to hear about it in the comments.For me, the limitations far outweigh the benefits, and theres usually another way to accommodate multiple users.Too Many Missing Features.After you share a workbook, many of Excels features cant be used.Theres a list of unavailable features for Excel 2.Microsoft site, and in Excels help.For example, you cant add any of the following features, and in some cases you cant even change the existing items Conditional Formatting.Data Validation. Lists.Protection. Pivot Tables.If you do need to create a shared workbook, check the list of restricted features, and make sure you have everything set up exactly the way you want it, before you share the file.Test everything after you share the file, because things might not work the way they did before.Alternatives to Shared Workbooks.What can you do insteadHmmm.Ive often found its quicker and easier to simply link the charts to a PowerPoint, meaning that any time you update the.This article explains how you can overcome the message Automatic update of links had been disabled, that appears when you open a workbook.VBA Code Excel Macro Examples Useful 100 Macros, Codes and How Tos explained Basic Beginners, Advanced users.Learn Excel 2003, 2007, 2010, 2013 Macros.Forums/getfile/793661' alt='Excel Vba Update Links On Opening' title='Excel Vba Update Links On Opening' />Find out exactly what the workbooks purpose is, and why multiple people need to use it.If users are entering data, they could get in and out of the workbook quickly, so another person has a chance to enter their data.Excel will notify the next user when the workbook is available.If users need the workbook as a calculator, make the file read only, or save it as a template, so anyone can open a copy.Users can save the file with a different name, if they need to save their work.If users enter data on separate sheets, create separate workbooks instead.Then, create a summary workbook to pull all the data together.If users need to enter data many times throughout the day, a database might be a better option. Adobe Acrobat Writer Download Rapidshare For Free . If you have other solutions, Id like to hear them.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |