Appendix E – Excel 2016 Troubleshooting
You will see the yellowish Create Relationships box appear sometimes but creating a relationship is not the answer. Frequently, this yellow box can be cleared simply by relocating a recent field addition. If you recently added a field with numerical data, Excel automatically placed the field in the Values quadrant and either summed or counted it as well. Try moving the field over to the Rows quadrant. There’s a good chance that will clear the yellow create relationship box and you can continue on with your work (FIGURE 1).
|
FIGURE 1
|
Excel has an interesting way of keeping track of dates. It uses what is known as the “1900 date system”, which means Excel begins tracking each consecutive day as a running number total, beginning with January 1, 1900 as day 1. Microsoft Excel for Macintosh uses the 1904 date system, so that system begins tracking each consecutive day as a running total, with January 1, 1904 as day 1.
The problem is that your date field shows only large numbers, as shown in FIGURE 4. |
FIGURE 4
|