...
- Redo all the formulas:
- Work on the left-most set of totals (at the very bottom of the sheet).
- Double click on "Users"; the formula will appear.
- Go to the formula bar at the top of excel.
- =SUM(B194+B184+B174+B164+B144+B134+B124+B114+B104+B94+B84+B74+B64+B54+B44+B34+B24+B14+B4)
- Notice that there is no "B154" in the formula.
- Type in the missing value.
- Click "Enter" on your keyboard.
- Repeat this process for each value in turn: Users, Libraries, Albums, Slideshows, Saved Searches, Images, Total, Total Size.
- Replace all the sheet formulas:
- Select on column of totals.
- Hover over the lower right-hand corner until you get the "cross" icon.
- Hold down your mouse key; the icon will change to a little box.
- Holding down your mouse key, drag to the right until you get to the end of the year.
- Now you are ready to import with the new domain's data.