We meet the hyperlinks every day while surfing the Internet, and they have long time ago become part of Office applications. In Excel, this is often an unfairly ignored functionality. In addition to allowing you to go to an Internet presentation or write a letter to the specified e-mail address, a link can also be used to create a new document or position it on a prefix in an existing document.
When making reports, multiple Excel documents are often used. As you know, data in another worksheet or other document, if it is open, we can easily access by specifying the absolute address of a cell or cell range. But what if we want to access a closed document? And can Excel be used as a data repository? About the link to other Excel files more in the text that follows.
At every company there are certain data that should be kept secret. Also, sometimes we do not want everyone to be able to edit the document, especially when it comes to corporate reports that should have a unique form. Since Excel is a tool frequently used for budgets or as a tool for interpreting business reports, it’s important to know how to protect individual worksheet elements, the structure of the workbook, and the workbook as a whole.
Each document we create in Excel contains information about the name of the author as well as other properties that are automatically generated, and they say: when the document was made, when the last time it was changed and who changed it, what size was it, where it was finds, etc. After saving a document, if we want to share it with other users, it’s useful to check compatibility, accessibility and whether it has hidden information…
Tracking changes to a document is used when multiple users are working in its editing. It is done so that we can see which user has made the changes, so that we can remove errors or make other changes that will improve the final version. This option only applies to shared documents. Even if we did not share it, after activating the tracking changes option it will become a shared document.