Inside Microsoft Excel

Tailor your workbook’s data while ensuring a clean slate for coworkers

Inside Microsoft Excel

by Kara Hiltz

When you keep a workbook on a network, one colleague may apply different settings or views, leaving the next coworker confused and possibly unable to make the adjustments necessary to view the data she needs. You can set up protections and securities, but this may limit employees’ ability to modify the data. For instance, if you have data for three departments of the company in one workbook, you don’t want to prevent[…]


Subscribe to Inside Microsoft Excel

(get full access to archives and more)