The solution: Create a Table of Contents for complex Excel workbooks This can lead to misinterpretation, erroneous decision making and chaos. This is a communication gap – which is difficult to bridge. The sender may have intended you to look at a particular sheet / range but in reality, you end up looking at some other area – and take some decision. Which does not necessarily mean that is the area of primary interest. Where do I start? Which areas am I supposed to view? The first sheet which opens is the sheet and the area of the sheet which was open at the time of last file save.
How often have you received complex Excel files from others which have many worksheets, some color coded (but you don’t know the meaning of the color), some having similar names …lots of data, calculations, pivots, charts … and then you face a simple problem.
0 kommentar(er)
