For our budgeting purpose, I have created an input schedule that allows expansion, and I need to default the Current View to certain settings while not "locking" it. To prevent the users from accidentally expanding the input schedule with their CV, I wish to save a specific CV for this input schedule. For instance, I want my Account Dimension to be "Balance_Sheet" rather than their CV, especially when the CV is easy to change when toggling back and forth different reports and input templates.
I have checked "Save the active session CV with this workbook", under eTools --> Workbook Options. However, after I saved and reopened the input schedule, it didn't show the CV that I saved.
Is there any bug with the "Save the active session CV with this workbook"? Or I am having the wrong idea about this option?
In addition, is there a way to use Macro to set CV in Workbook_Open() function?
Thank you! Happy Memorial Weekend!