We've recently had a number of people asking why their gridlines / freeze panes have been disappearing from their Modano models, so thought it worth addressing in the forum.
Important to note that this is all normal Excel behaviour and nothing related specifically to Modano - the effect is just more noticeable with our models, as we remove gridlines and apply freeze panes on a best practice basis.
Root Cause
The cause of the issue is opening multiple windows for the same workbook, via VIEW / NEW WINDOW:
If the " - 2" window is closed then original window will be left as the only open window, with all of the model's gridlines and freeze panes left as originally established.
However, if the original " - 1" window is closed, i.e. the one with all the original settings, the user will be left with the appearance of the second " - 2" window, i.e. no gridlines and no freeze panes:
As noted, this is normal Excel behaviour, nothing specific to Modano.
The correct action is simply to close " - 2" whenever using multiple windows.
Resolution
Where the above issue has occured, then the resolution is to (a) hide gridlines and (b) re-freeze the panes in the most suitable location - much of which is managed by Modano.
To put gridlines back, select all worksheets and then (BUILD / ) TOOLS / PRINTING & VIEWING / SHOW/HIDE GRIDLINES:
This will turn off gridlines throughout the model.
To reset the freeze panes, select the applicable cell on the worksheet and then (BUILD / ) TOOLS / PRINTING & VIEWING / RESET PANES:
As shown in the above image, where the user is reseting the panes on a worksheet with time series analysis, Modano will provide the option to automatically reset the panes on all associated types of time series sheets with the freeze pane cell.
Where the user is reseting the panes on a worksheet with grouped / hidden historical periods, it is important to ungroup these columns before then selecting a cell in the first period column - shown above for $J$15. Failure to do so will result in a freeze pane further out into the forecast periods, which is not the desired result.
Cheers. J.